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...? I've forgotten the exact cursor syntax, but it's like: $query = "declare cursor foo as select complicated query here"; $foo = pg_exec($connection, $query); $query = "select 10 from foo"; $ten_rows = pg_exec($connection, $query); I have completely forgotten the cursor query to get the number of rows, but it's in the docs. You are so totally on your own with that bleeding-edge PDO [bleep]. Sorry. -- 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
