On Thu, June 15, 2006 11:11 am, D. Dante Lorenso wrote: > I just discovered this neat little gem in MySQL which makes it easy to > page large result sets: > > * SELECT SQL_CALC_FOUND_ROWS * > > * SELECT FOUND_ROWS() > > I can't seem to find the equivalent of it in PostgreSQL! The only > options I see are: > > 2. > > Using PHP row seek and only selecting the number of rows I need. 3. use the built-in "cursor" of PostgreSQL which pre-dates MySQL LIMIT and OFFSET clauses, which are non-standard hacks Rasmus introduced back in the day. -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php