At 11:11 AM -0500 6/15/06, D. Dante Lorenso wrote:
I can't seem to find the equivalent of it in PostgreSQL! The only options I
see are:
1.
TWO queries. The first query will perform a SELECT COUNT(*) ...; and the
second query performs the actualy SELECT ... LIMIT x OFFSET y;
-snip-
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
Richard Lynch wrote:
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.
Care to elaborate? Cast into context of PDO if you can...?
Dante
--
PHP General Mailing List (http://www.php.net/)
To
On Thu, June 15, 2006 7:15 pm, D. Dante Lorenso wrote:
Richard Lynch wrote:
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.
Care to elaborate? Cast into context of PDO if you can...?
4 matches
Mail list logo