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! >
