Re: paging results in large resultsets: mysql vs postgresql?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux