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
