[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Erw-devel] LIMIT error with PostgreSQL
From: |
erw-devel |
Subject: |
Re: [Erw-devel] LIMIT error with PostgreSQL |
Date: |
27 Jun 2003 11:19:43 +0200 |
On Fri, 2003-06-27 at 09:58, address@hidden wrote:
> From PostgreSQL 7.3 (and maybe earlier -- haven't checked), LIMIT needs
> to be be done as:
>
> SELECT ... ORDER BY ... LIMIT n OFFSET x ... ;
> n = number of rows to return
> x = number of rows to skip
>
> The patch for ERW.php is:
> 1566d1565
> < case "pgsql": return "LIMIT $count OFFSET $offset";
You're right--I already patched the current beta, but I never released it.
The LIMIT x,y syntax was supported up to 7.2, then they dropped.
I wonder what Oracle would prefer.
Ciao,
seba