> 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
According to my testing, correct. PostgreSQL SQLException: ERROR: LIMIT must not be negative SQLState: 2201W VendorError: 0 SQLite SQLException: [SQLITE_ERROR] SQL error or missing database (near "ALL":syntax error) SQLState: null VendorError: 1 SELECT * FROM key_table4 OFFSET 2 SQLException: [SQLITE_ERROR] SQL error or missing database (near "2": syntax error) SQLState: null VendorError: 1