Re: Re: Problems with PEAR::DB limitQuery
| From: | Jeroen Houben | Date: | Mon, 08 Dec 2003 15:12:39 +0000 |
| Subject: | Re: Re: Problems with PEAR::DB limitQuery | ||
| References: | 1 2 3 | Groups: | php.pear.dev php.pear.general |
| Request: | Send a blank email to pear-dev+get-24268@lists.php.net to get a copy of this message | ||
Alexey Borzov wrote:
Hi! Jeroen Houben wrote:JeroenIn older versions the LIMIT #, # *was* correct. From the postgresql changelog @ http://developer.postgresql.org/~momjian/HISTORY.html (under migrating to 7.3) : Disable LIMIT #,# syntax; now only LIMIT # OFFSET # supported (Bruce) So the class should do a version check and then execute the proper code. HTH,The class should NOT do any version check, as LIMIT # OFFSET # syntax is valid for all PostgreSQL versions, which is not true for LIMIT #,#. Martin is right. I didn't know it was valid for *all* versions. In that case yes PEAR::DB should use LIMIT # OFFSET. I was under the impression that older versions 6.x (and even 7.0) could only work with LIMIT #,#.