Author: hans.spaans
Description:
Rewrite LIMIT #,# to LIMIT # OFFSET #
The current SELECT statement fails on PostgreSQL since it doesn't support LIMIT #,#, but both MySQL and PostgreSQL do support LIMIT # OFFSET #. The patch attached should make the SELECT statement work with both MySQL and PostgreSQL.
http://dev.mysql.com/doc/refman/5.1/en/select.html
http://www.postgresql.org/docs/8.3/static/sql-select.html
Version: unspecified
Severity: minor
attachment mwe-newestpages-r50851-hspaans-1.patch ignored as obsolete