Re: Problems with PEAR::DB limitQuery
| From: | Martin Marques | Date: | Mon, 08 Dec 2003 15:15:36 +0000 |
| Subject: | Re: Problems with PEAR::DB limitQuery | ||
| References: | 1 2 | Groups: | php.pear.dev php.pear.general |
| Request: | Send a blank email to pear-dev+get-24270@lists.php.net to get a copy of this message | ||
El Lun 08 Dic 2003 11:46, Jeroen Houben escribió:
> Hi,
>
> In 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.
Not really.
Older then 7.3 versions of PostgreSQL supported both ways of using LIMIT, so
with the change I sent all 7.x versions of PostgreSQL would work OK.
P.D.: Don't really know about old 6.x versions, but they have been depricated,
and should not be used.
--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
-----------------------------------------------------------------
Martín Marqués | mmarques@unl.edu.ar
Programador, Administrador, DBA | Centro de Telemática
Universidad Nacional
del Litoral
-----------------------------------------------------------------