Re: [PEAR] Re: DB getRow() and limit 1

On Wed, 24 Nov 2004 22:59:29 +0100, Lukas Smith <lsmith@php.net> wrote:
> Brice Joly wrote: 
>
> no it does not.
>

Because some DB backends don't support it or have different syntax for
it? Could the backends which support it implement a wrapper which adds
it?

--
Justin Patrin

Justin Patrin wrote:
> On Wed, 24 Nov 2004 22:59:29 +0100, Lukas Smith <lsmith@php.net> wrote:
> 
>
>
> Because some DB backends don't support it or have different syntax for
> it? Could the backends which support it implement a wrapper which adds
> it?

there is emulation in place for all relevant drivers to handle limit.
however in some cases its rather nasty, so the best way is just to write
proper queries.

regards,
Lukas

Lukas Smith wrote:
> Justin Patrin wrote:
> 
>
>
> there is emulation in place for all relevant drivers to handle limit.
> however in some cases its rather nasty, so the best way is just to write
> proper queries.

note however that I have added it to MDB2 a while back if i remember
correctly. The two main reasons why I have it there is that in MDB2 its
easier to combine limits with any query that executes a query and also I
have stayed away from overly complex limit emulations (which means that
for those RDBMS they get a more severe performance hit when people rely
on limit).

regards,
Lukas