[Erw-devel] LIMIT error with PostgreSQL

[erw-devel]

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";

Share and enjoy.

-------------------------------------------------------------
Larry Stanbery, RHCE            address@hidden
Network Manager                 phone: 0985-85-5931
Miyazaki International College  http://www.miyazaki-mic.ac.jp
GPG Key ID: 2CEFA662