Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fKTyz-0008MU-KU for pgsql-hackers@arkaria.postgresql.org; Sun, 20 May 2018 19:27:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fKTyv-0002U0-Lh for pgsql-hackers@arkaria.postgresql.org; Sun, 20 May 2018 19:27:01 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fKTyv-0002Tq-4r for pgsql-hackers@lists.postgresql.org; Sun, 20 May 2018 19:27:01 +0000 Received: from xvm-110-146.dc2.ghst.net ([46.226.110.146] helo=fetter.org) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fKTym-00054Y-V6 for pgsql-hackers@postgresql.org; Sun, 20 May 2018 19:26:59 +0000 Received: by fetter.org (Postfix, from userid 1001) id 828E7417E8; Sun, 20 May 2018 21:26:50 +0200 (CEST) Date: Sun, 20 May 2018 21:26:50 +0200 From: David Fetter To: Andrew Gierth Cc: Tom Lane , Vik Fearing , pgsql-hackers@postgresql.org Subject: Re: Fix for FETCH FIRST syntax problems Message-ID: <20180520192649.GA20752@fetter.org> References: <877enz476l.fsf@news-spur.riddles.org.uk> <22981.1526770675@sss.pgh.pa.us> <03da97fc-9d6b-cbe1-c28f-cee7c1ba5c38@2ndquadrant.com> <25267.1526773270@sss.pgh.pa.us> <87y3gf2mep.fsf@news-spur.riddles.org.uk> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <87y3gf2mep.fsf@news-spur.riddles.org.uk> User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Sun, May 20, 2018 at 01:39:27AM +0100, Andrew Gierth wrote: > >>>>> "Tom" == Tom Lane writes: > > >> I'm +1 for backpatching it. It may be operating as designed by > >> PeterE ten years ago, but it's not operating as designed by the SQL > >> standard. > > Tom> By that argument, *anyplace* where we're missing a SQL-spec > Tom> feature is a back-patchable bug. I don't buy it. > > But this is a feature we already claimed to actually support (it's > listed in sql_features with a bunch of unqualified YES entries), but in > fact doesn't work properly. This looks like a bug fix to me, for what it's worth. Best, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate