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 1lFtqD-0000oq-P9 for pgsql-hackers@arkaria.postgresql.org; Sat, 27 Feb 2021 07:16: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 1lFtqC-0003UH-N8 for pgsql-hackers@arkaria.postgresql.org; Sat, 27 Feb 2021 07:16:40 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lFtqB-0003U9-Qp for pgsql-hackers@lists.postgresql.org; Sat, 27 Feb 2021 07:16:40 +0000 Received: from wforward2-smtp.messagingengine.com ([64.147.123.31]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lFtq4-00044Y-Li for pgsql-hackers@postgresql.org; Sat, 27 Feb 2021 07:16:38 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailforward.west.internal (Postfix) with ESMTP id 398F39F6; Sat, 27 Feb 2021 02:16:29 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Sat, 27 Feb 2021 02:16:29 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm2; bh=P11ypaC44cQ5087RMJoDM8QySy6ddWYHwh8SGa32N Zo=; b=nyzDHSSqtypBOQQdK6LxWGJD2ixYa9QeOfePIKrLmKT+NoyEas/GXxpuF 6rMxK0fcRMiyOI0kmUPVulEQ6z6P1DmoLE/WrWJUSupYFH6pucJbZCuBQPvcc2ES R6EUMru1lls5kRVt+UFFMQEKwSq2D4YLuyHcg/1xMzztrPxwOh4nruqDFkiY1UCo DwCLz346oEwX7XxINsEGl1yy8pqaxKFcqCg2sunukfFER57DrS1gYtI0S5SREuIV 2inO169vazgea42bpRa+t6KUAO1BeeiXE3TzO7TT8SVbCH+Gm94to4qbXrlIWWf8 Pj3A5W0bVetVmrPwDnDicOfhN6mjw== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrledvgddutdejucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucenucfjughrpefuvfhfhffkffgfgggjtgfgsehtke ertddtfeejnecuhfhrohhmpefrvghtvghrucfgihhsvghnthhrrghuthcuoehpvghtvghr rdgvihhsvghnthhrrghuthesvdhnughquhgrughrrghnthdrtghomheqnecuggftrfgrth htvghrnheptedtgeetueelvddufeeitdellefhgfdvteetgfekvedvieeggefgleeigfdv gedtnecukfhppeekjedrudejjedrieelrddugedtnecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepphgvthgvrhdrvghishgvnhhtrhgruhhtsedv nhguqhhurggurhgrnhhtrdgtohhm X-ME-Proxy: Received: from laptop206oxuk.local (p57b1458c.dip0.t-ipconnect.de [87.177.69.140]) by mail.messagingengine.com (Postfix) with ESMTPA id DFB8D1080063; Sat, 27 Feb 2021 02:16:26 -0500 (EST) Subject: Re: SEARCH and CYCLE clauses To: Vik Fearing , pgsql-hackers References: <54e533c5-09e5-7f41-9892-d4e0f7c62598@postgresfriends.org> <1cfc9079-9595-d167-00e6-5014438cc3e2@2ndquadrant.com> <9ce4d370-048c-1d67-fffb-a86f17120132@postgresfriends.org> <3c931f0f-6f53-598d-702f-1e6e932690ab@2ndquadrant.com> <82b6e6ca-e138-81a6-673d-20cfbdc4ec3e@postgresfriends.org> <3e092df8-3844-2d29-beb5-16c866554936@2ndquadrant.com> From: Peter Eisentraut Message-ID: <450aa025-7a7f-8374-48e1-964a149f0790@2ndquadrant.com> Date: Sat, 27 Feb 2021 08:16:13 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.16; rv:78.0) Gecko/20100101 Thunderbird/78.7.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 22.02.21 14:45, Vik Fearing wrote: > On 2/22/21 1:28 PM, Peter Eisentraut wrote: >> On 22.02.21 11:05, Vik Fearing wrote: >>> This looks good to me, except that you forgot to add the feature stamp. >>>   Attached is a small diff to apply on top of your patch to fix that. >> >> The feature code is from SQL:202x, whereas the table is relative to >> SQL:2016.  We could add it, but probably with a comment. > > OK. > done