On Thu, May 12, 2016 at 6:07 PM, dandl <david at andl.org> wrote: > > > 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. > > > > Yes and Yes. Documented behaviour. There are some strange situations if > the > > two clauses can't both be satisfied, but if you're not playing silly > tricks > > you can depend on negative limits. > > Thanks. I ran across this: > http://www.pgcon.org/2014/schedule/events/736.en.html > > Richard Hipp seems to be on record as saying: > "SQLite can be thought of as a derivative of PostgreSQL. SQLite was > originally written from PostgreSQL 6.5 documentation, and the SQLite > developers still use PostgreSQL as a reference platform to verify that > SQLite is working correctly." > > Not a major problem for me, just an interesting footnote. >
The way I recall hearing it expressed in talks I've watched (recorded after the fact, never live) is that when situations arise that need resolution, the question is often asked "what does PostgreSQL do?" Sadly, the backward compatibility requirements prohibit SQLite from being a 100% feature / implementation match. -- Scott Robison
