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 1japDW-00083T-QM for pgsql-hackers@arkaria.postgresql.org; Mon, 18 May 2020 23:30:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1japDV-0001Vg-Ly for pgsql-hackers@arkaria.postgresql.org; Mon, 18 May 2020 23:30:41 +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 1japDV-0001VZ-AE for pgsql-hackers@lists.postgresql.org; Mon, 18 May 2020 23:30:41 +0000 Received: from mail-qk1-x743.google.com ([2607:f8b0:4864:20::743]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1japDS-0004z0-94 for pgsql-hackers@lists.postgresql.org; Mon, 18 May 2020 23:30:40 +0000 Received: by mail-qk1-x743.google.com with SMTP id 190so12503767qki.1 for ; Mon, 18 May 2020 16:30:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=075mPsaK6JPx2Tsl4h6YEl9fXHFyRv9BhgnzMeFrIIk=; b=qAYM5hTbL/gjTeJZRTTqO/EwRV7ZxcLu8+ya/FqTB+3Xr2KWka8jaeJZNpAQxhq5Dx EmDCURak6zh6fe/H7oiLnBJo8kDVMwuoFwH+80WX/yKZFv3fxbm0yEz1yxggU4TgAysF iIAhAEDjKtys7U6OCHg7IQe6N/ZX0I1xhgKJYBMWLfLQ3gILBSYkA9nOWO9s05DyZpce ikBhNfXWiG179TnuwZ93GYZjiFEF7wZ0X9vf80P+Id/INYi0QDLkzdo4tWvzwEP9Y3uv 8X2ArBzU7/7LHYX3wXaa2/4wICWGw9TBJ65zY3ThKsmklTYWPENqc2BfL84HGEXtOEn3 bCWg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=075mPsaK6JPx2Tsl4h6YEl9fXHFyRv9BhgnzMeFrIIk=; b=BnDArKt+AJb2z7e616y5hzn0MXwSS9ME7Wr0bXos4+YCL0bFV0+EIz3ZaRyPwrLubx c5c9k+2jCVrymMKAOJ87gxjTI7tBvHJoXqCZ7uPzqT/xJ7M5f93CNZj3ctJzXeoQ3mEj BTkHaKZQvg/3T/FpRMwT/p4y0gRpjq//Psp/tlBVE626v7nnd/n9JWbFCQiPKlFwZq+i 36EdnFzQFUYFENXXvqhnGq6pTZfOkgqPcD/S0UJq3ZqxAx7TQJ9V/BYJ0Voqj8JWDEBk 55uKN1Y1LXR//zc60roj2CJP6aukDmPgxsFnIJVQbj2LwtQ8sbxA45HdYvCLmbrGARFT qMww== X-Gm-Message-State: AOAM533VNmEFtvTE7v3jQQ/i+tT78mYu5tWmvlynO6NCaQjTP5LSe2j2 Zjxj5L0su/Y+GOJ6XBjtvN4G7VFx1EbzJ+w0lc2yKQ2wZxQF/VZmf+J/c+6MKZFZ4LfkEQDfQsQ PXPQ9wj+u/A/IdT8GZWp/3e7nTZISyNrszsyQArTxJ2/TBGzsR+f1RXNhFDXHQK9RnJeERxtXU1 XN7gyypb1OMez0YzZZ X-Google-Smtp-Source: ABdhPJwTcI7rdPbeuffGuPIyXcUUM+fle2EdJQvxK7e8+i5OsEYKcDyUCcP3QutNxw8VjRgzdCaPZA== X-Received: by 2002:a05:620a:2f8:: with SMTP id a24mr18360056qko.22.1589844635760; Mon, 18 May 2020 16:30:35 -0700 (PDT) Received: from nimloth.alvh.no-ip.org ([190.95.18.252]) by smtp.gmail.com with ESMTPSA id c25sm9252034qkm.119.2020.05.18.16.30.34 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 18 May 2020 16:30:34 -0700 (PDT) Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000) id 65CB230076A; Mon, 18 May 2020 19:30:32 -0400 (-04) Date: Mon, 18 May 2020 19:30:32 -0400 From: Alvaro Herrera To: Vik Fearing Cc: PostgreSQL Hackers Subject: Re: Missing grammar production for WITH TIES Message-ID: <20200518233032.GA32205@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20200518170323.GA14610@alvherre.pgsql> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-May-18, 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. Done. Thanks! -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services