It's a minor point, but can someone confirm that:

Postgres accepts (but Sqlite does not)
LIMIT ALL
LIMIT ALL OFFSET nnn
OFFSET nnn

Sqlite accepts (but Postgres does not):
LIMIT -1 OFFSET nnn
LIMIT -1

These all have the same meaning of no limit, but there is no common ground
in the syntax.

Regards
David M Bennett FACS

Andl - A New Database Language - andl.org


Reply via email to