Postgres Pro
Downloads
Home   >   mailing lists

Page Management - Mailing list pgsql-sql

From Samuel J. Sutjiono
Subject Page Management
Date
Msg-id 01b101c1bbb3$8725dc30$110a010a@headquarters.wcgroup.com
Whole thread Raw
Responses Re: Page Management  ("Nick Fankhauser" <nickf@ontko.com>)
List pgsql-sql
Tree view
Hello,
 
I have a question on page management. I want my web page to display the first 10 rows (of 100 in the result set).  If user clicks next page, it executes the same SQL (in Stored Procedure) and displays records 11-20.  What is the most efficient way to accomplish this ?   Should I use LIMIT and OFFSET or Fetch from cursor ?
 
I appreciate any help.
 
Regards,
Sam

pgsql-sql by date:

Previous
From: "Samuel J. Sutjiono"
Date:
Subject: How does Index Scan get used
Next
From: Roberto Mello
Date:
Subject: Re: Postgres vs. Mysql