Kgd,
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.
Andy
>
> Curious; I've never seen this format. I've been using the first for
> some time now with 7.2.something (Debian Woody), and more recently
> 7.4.something (Debian Sarge). No problems. Most access is via Perl
> DBI, but the exact same SQL works just fine from a psql shell.
>
> -kgd
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
> !DSPAM:14,4469e57e34496068418624!
>