Pi

October 29, 2009

Postgres Paginations

Filed under: Uncategorized — rqmedes @ 6:07 am

As a follow up on pagination in MSSQL the pagination technique also works in postgres.

Pagination in MSSQL with total number of records.

although it is alot simpler in postgres
SELECT * , count(*) OVER()as total from “Table” limit 20 OFFSET 10

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: