X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 075E39FA15C for ; Tue, 16 May 2006 13:06:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 96539-02 for ; Tue, 16 May 2006 13:06:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp.vianet.ca (smtp.vianet.ca [209.91.128.40]) by postgresql.org (Postfix) with SMTP id 4E9809F9C9E for ; Tue, 16 May 2006 13:06:46 -0300 (ADT) Received: (qmail 31775 invoked from network); 16 May 2006 16:06:46 -0000 Received: from unknown (HELO ?192.168.99.15?) (209.91.179.117) by smtp.vianet.ca with SMTP; 16 May 2006 16:06:46 -0000 Message-ID: <4469F86D.7040706@vianet.ca> Date: Tue, 16 May 2006 12:06:05 -0400 From: Kris Deugau Reply-To: pgsql-admin@postgresql.org Organization: ViaNet User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: reg:Query References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/218 X-Sequence-Number: 21750 [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. 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