Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jalQE-0000XP-7Q for pgsql-hackers@arkaria.postgresql.org; Mon, 18 May 2020 19:27:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jalQB-0005xf-Sq for pgsql-hackers@arkaria.postgresql.org; Mon, 18 May 2020 19:27:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jalQB-0005xY-Lf for pgsql-hackers@lists.postgresql.org; Mon, 18 May 2020 19:27:31 +0000 Received: from relay12.mail.gandi.net ([217.70.178.232]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jalQ9-0002p1-D8 for pgsql-hackers@lists.postgresql.org; Mon, 18 May 2020 19:27:31 +0000 Received: from [172.16.255.146] (unknown [88.124.33.232]) (Authenticated sender: vik@postgresfriends.org) by relay12.mail.gandi.net (Postfix) with ESMTPSA id 45ACB200006; Mon, 18 May 2020 19:27:26 +0000 (UTC) Subject: Re: Missing grammar production for WITH TIES To: Alvaro Herrera Cc: PostgreSQL Hackers References: <20200518170323.GA14610@alvherre.pgsql> From: Vik Fearing Message-ID: Date: Mon, 18 May 2020 21:27:26 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.7.0 MIME-Version: 1.0 In-Reply-To: <20200518170323.GA14610@alvherre.pgsql> Content-Type: text/plain; charset=windows-1252 Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 5/18/20 7:03 PM, Alvaro Herrera wrote: > On 2020-May-18, Vik Fearing wrote: > >> The syntax for FETCH FIRST allows the to be >> absent (implying 1). >> >> We implement this correctly for ONLY, but WITH TIES didn't get the memo. > > Oops, yes. I added a test. Will get this pushed immediately after I > see beta1 produced. Thanks! -- Vik Fearing