Re: [Erw-devel] LIMIT error with PostgreSQL

[erw-devel]

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