[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.



reply via email to

[Prev in Thread] Current Thread [Next in Thread]