[Please keep mail on-list; I don't need multiple copies. Thanks.]
Andy Shellam wrote:
> I think it changed in 8.0 onwards.
>
> I used an application that was written for 7.4 on my 8.0.3 server, and it
> threw up errors at the LIMIT statements, saying the "LIMIT X,Y" format was
> deprecated, and to use "LIMIT X OFFSET Y" instead - so I had to have much of
> the application queries rewritten.
>
> Ref: section 7.6 in the 8.1-series manual.
>
> I'm sure you could use both pre-8.0 - it's just that the LIMIT X,Y format
> was withdrawn after 8.0.
Er, that's what I meant: I've never seen the LIMIT X,Y format, but I've
been using the LIMIT X OFFSET Y format with both 7.2 and 7.4.
(Actually, IIRC, this is one of the few bits of code of any kind in my
particular app that's still hanging around from before I took over
maintenance... when it ran on MySQL. <G> I quickly switched over to
Postgres for quite a long list of reasons.)
Your earlier messages in the thread seemed to imply that LIMIT X,Y was
the ONLY format that would work pre-8.0. Which definitely isn't the
case - unless I've been using some mutated third-party-patched versions
of Postgres. (Entirely possible given that I usually install
distribution packages rather than build-from-source- although I'd be
very surprised if this was one of the changes.)
-kgd