You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cocoon.apache.org by bu...@apache.org on 2002/12/04 14:29:38 UTC
DO NOT REPLY [Bug 15064] New: -
[PATCH] (Chris) Postgresql 7.3: LIMIT x,y no longer supported
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15064>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND
INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15064
[PATCH] (Chris) Postgresql 7.3: LIMIT x,y no longer supported
Summary: [PATCH] (Chris) Postgresql 7.3: LIMIT x,y no longer
supported
Product: Cocoon 2
Version: Current CVS
Platform: PC
OS/Version: Linux
Status: NEW
Severity: Normal
Priority: Other
Component: general components
AssignedTo: cocoon-dev@xml.apache.org
ReportedBy: michael.enke@wincor-nixdorf.com
since postgresql 7.3, the syntax "LIMIT x,y" has changed to "LIMIT x OFFSET y"
This must be reflected in EsqlQuery.java
This works also for pre 7.3 postgres (I have 7.2.3) but I don't know since when.
EsqlQuery.java simplifies to:
case EsqlConnection.LIMIT_METHOD_POSTGRESQL:
if (maxRows > -1) query = query + " LIMIT " + maxRows;
if (skipRows > 0) query = query + " OFFSET " + skipRows;
case EsqlConnection.LIMIT_METHOD_MYSQL: ...
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org