ox-it / ords

Automatically exported from code.google.com/p/ords
0 stars 0 forks source link

OFFSET in queries doesn't work unless there's also a LIMIT clause #711

Open MerielP opened 9 years ago

MerielP commented 9 years ago

To reproduce, use the SQL query page to write a query, including an OFFSET clause but no LIMIT one. The result is an error message.

The PostgreSQL documentation (http://www.postgresql.org/docs/9.1/static/queries-limit.html) strongly implies it should be possible to have an OFFSET clause but not a LIMIT one. It also notes that LIMIT NULL is equivalent to omitting the LIMIT clause - except in the ORDS, LIMIT NULL works, whereas omitting the LIMIT clause doesn't.