From: Kris Deugau <kdeugau@vianet.ca>
To: pgsql-admin@postgresql.org
Subject: Re: reg:Query
Date: Tue, 16 May 2006 12:06:05 -0400
Message-ID: <4469F86D.7040706@vianet.ca> (raw)
In-Reply-To: <!~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAAC4AAAAAAAAAt+qV6pqKPEmXG74TlFgX5gEAlpDSN+DrMEWnumhoRHpQKQAAAbLc9wAAEAAAAKYL8YdRxdhBuHdm0OcFFukBAAAAAA==@mailnetwork.co.uk>
References: <!~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAAC4AAAAAAAAAt+qV6pqKPEmXG74TlFgX5gEAlpDSN+DrMEWnumhoRHpQKQAAAbLc9wAAEAAAAKYL8YdRxdhBuHdm0OcFFukBAAAAAA==@mailnetwork.co.uk>
[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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: kdeugau@vianet.ca
Subject: Re: reg:Query
In-Reply-To: <4469F86D.7040706@vianet.ca>
References: <!~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAAC4AAAAAAAAAt+qV6pqKPEmXG74TlFgX5gEAlpDSN+DrMEWnumhoRHpQKQAAAbLc9wAAEAAAAKYL8YdRxdhBuHdm0OcFFukBAAAAAA==@mailnetwork.co.uk> <4469F86D.7040706@vianet.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox