Re: paging results in large resultsets: mysql vs postgresql?
| From: | Richard Lynch | Date: | Fri, 16 Jun 2006 01:32:53 +0000 |
| Subject: | Re: paging results in large resultsets: mysql vs postgresql? | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-238130@lists.php.net to get a copy of this message | ||
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