Re: Problems with PEAR::DB limitQuery
| From: | Martin Marques | Date: | Mon, 08 Dec 2003 15:16:25 +0000 |
| Subject: | 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-24271@lists.php.net to get a copy of this message | ||
El Lun 08 Dic 2003 11:56, Alexey Borzov escribió:
> Hi!
>
> Jeroen Houben wrote:
> > 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.
> > 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.
:-)
Got late to this mail.
--
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
-----------------------------------------------------------------