On Fri, Feb 22, 2002 at 02:43:31AM -0600, Thomas T. Thai wrote:
> i did a pg_dumpall in 7.2, and tried to load that file back into 7.3 snap
> from today and got many errors. some tables even failed to load. also, in
> one of my script, LIMIT X,X worked in 7.2, now it gave an error about
> using LIMIT and OFFSET. did something change there?
Dunno about the first problem but the LIMIT code did indeed change. IIRC the
LIMIT X,Y is non-standard and postgres happened to to have the meaning
switched around compared to other databases (by accident).
So rather than supporting the ambiguous and incompatably implemented
LIMIT X,Y stuff it was ripped out and people told to use the unambiguous
LIMIT/OFFSET instead.
Something like that anyway. The archive should have more details.
HTH,
--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/
> If the company that invents a cure for AIDS is expected to make their
> money back in 17 years, why can't we ask the same of the company that
> markets big-titted lip-syncing chicks and goddamn cartoon mice?