Re: fetching rows - Mailing list pgsql-sql

From K Parker
Subject Re: fetching rows
Date
Msg-id NOBNBJMODFMJBAAA@shared1-mail.whowhere.com
Whole thread Raw
In response to fetching rows  ("Nikolay Mijaylov" <nmmm@nmmm.nu>)
List pgsql-sql
I hate to be the bearer of bad news, but if you're using PHP and you wanted to fetch just 25 rows at a time for a
singlepage, and then fetch more when the user clicks on a NEXT button or link, you're completely out of luck.  Each
httptransaction is completely separate and so you can't maintain a cursor between pages.  Perhaps LIMIT would help you
here;but I've found it more useful to make sure there is a unique key for the order I'm displaying, and then say "WHERE
key> highest_key_value_on_current_page"
 




Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com


pgsql-sql by date:

Previous
From: "Nikolay Mijaylov"
Date:
Subject: fetching rows
Next
From: Jeff Hoffmann
Date:
Subject: Re: fetching rows