> > 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.
Absolutely so. Nevertheless, it would be pretty minor to add LIMIT ALL as a synonym for LIMIT -1. If you wanted to enhance compatibility. Regards David M Bennett FACS Andl - A New Database Language - andl.org