Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1sqUmY-00ABLC-FC
	for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Sep 2024 09:46:03 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1sqUmY-008PmR-5u
	for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Sep 2024 09:46:02 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <peter@eisentraut.org>)
	id 1sqUmW-008PmJ-Pe
	for pgsql-hackers@lists.postgresql.org; Tue, 17 Sep 2024 09:46:01 +0000
Received: from fhigh7-smtp.messagingengine.com ([103.168.172.158])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <peter@eisentraut.org>)
	id 1sqUmS-001d2a-RE
	for pgsql-hackers@lists.postgresql.org; Tue, 17 Sep 2024 09:46:00 +0000
Received: from phl-compute-06.internal (phl-compute-06.phl.internal [10.202.2.46])
	by mailfhigh.phl.internal (Postfix) with ESMTP id 8B7DA114031A;
	Tue, 17 Sep 2024 05:45:56 -0400 (EDT)
Received: from phl-mailfrontend-01 ([10.202.2.162])
  by phl-compute-06.internal (MEProxy); Tue, 17 Sep 2024 05:45:56 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eisentraut.org;
	 h=cc:cc:content-transfer-encoding:content-type:content-type
	:date:date:from:from:in-reply-to:in-reply-to:message-id
	:mime-version:references:reply-to:subject:subject:to:to; s=fm3;
	 t=1726566356; x=1726652756; bh=rcaBLxZFlE7tCo3M/srdJuib3jH3Uoku
	n9yE0/TI9WA=; b=DmpZpdpaq49DoEOivdeiLHPQTpidLx0h/qha/sulvqsmYD1G
	NBMb6U8PrNsKNzZU1TDA0N+JUob85o/KPv+Xf3SKin9cCnQG9Mw/F21Kbzbddjy2
	+1WJ9t4TaTYh7uqdM/SgOg/mSyeQvUkiBtt/RoNc5pzm/dG8CzBK2rJSapFTd5E/
	CbHMfAVjUkAbSrVnk8SrEg8W/104lHmrPZJcg/Wa92Wvkv4cL5WOQyOz6Vj+CoaR
	Y0Y6xdlng9PGR65h0j17ak3ZtkUIuVXIQNLBBakl1CK/KTiMsjBF2HtHFqOObbDY
	9+wT0cBrn8ORanVSuIS3iSqCFQehTVbk9Lsj2A==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:cc:content-transfer-encoding
	:content-type:content-type:date:date:feedback-id:feedback-id
	:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy
	:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1726566356; x=
	1726652756; bh=rcaBLxZFlE7tCo3M/srdJuib3jH3Uokun9yE0/TI9WA=; b=i
	UJuFKUJiO62e/hGdAesEiTWUI1ERoj4QM6Ga4N0xQz6GmEDNw0cgDbnXNgG2i4HV
	uqY7U8KTXoNbgvBAzv9sQidZAknY2KBuDwMLK1ccDmvOuIw+BrXkHrE3fQ6mDfJe
	SWbqAD9vi8tD5JTtUwNp9ZjzoioluFVuUQLKzFHFpzWhIXIN7ZmQjUSYh9TDBHkd
	e3Q9AVG3Smi5WeHikgZo6MGjaKG477astONKbTWQZZzCKxPqPDsMIcnI3IR77IU6
	dU1mDXBkonH7+yV/RN9nRT+Zpw9R6ZxJd/hJ1wzcRM463MV0EFtAlFdFDvxy9Bg7
	ttkqMbTCYhZ+xBwphm1/g==
X-ME-Sender: <xms:1E_pZv8lVMx0vggjbEl7svObaXhe3MkKpQzYD96mrAROvrdgc0e_qQ>
    <xme:1E_pZrtjAQt6L3LMXcd9HHXPLcVcn6aDOVn2NK6sYHWJ8ordBFXRxLcF72AdxDqrn
    B0cOJxOXyYSVEQFFA>
X-ME-Received: <xmr:1E_pZtDQ9QDKuUg8x_Y-kcUPPil_zTSzrfIiDvawhOMA4CrZBdvcHrMmWyHLqVmkVqbdPNRy0wsNg6hp2SHFSUvcd7Rqn7Lv>
X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrudekjedgvdduucetufdoteggodetrfdotf
    fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu
    rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh
    htshculddquddttddmnecujfgurhepkfffgggfuffhvfevfhgjtgfgsehtkeertddtvdej
    necuhfhrohhmpefrvghtvghrucfgihhsvghnthhrrghuthcuoehpvghtvghrsegvihhsvg
    hnthhrrghuthdrohhrgheqnecuggftrfgrthhtvghrnhepvdejiefhhfdvfeehveelkeev
    ueejhfeiudeuleejkeeijeeigeefhfdthfeljeegnecuvehluhhsthgvrhfuihiivgeptd
    enucfrrghrrghmpehmrghilhhfrhhomhepphgvthgvrhesvghishgvnhhtrhgruhhtrdho
    rhhgpdhnsggprhgtphhtthhopeeipdhmohguvgepshhmthhpohhuthdprhgtphhtthhope
    hpjhesihhllhhumhhinhgrthgvuggtohhmphhuthhinhhgrdgtohhmpdhrtghpthhtohep
    jhhirghnrdhunhhivhgvrhhsrghlihhthiesghhmrghilhdrtghomhdprhgtphhtthhope
    hishgrrggtrdhmohhrlhgrnhgusehgmhgrihhlrdgtohhmpdhrtghpthhtoheprhhosggv
    rhhtmhhhrggrshesghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlsehjqdgurg
    hvihhsrdgtohhmpdhrtghpthhtohepphhgshhqlhdqhhgrtghkvghrsheslhhishhtshdr
    phhoshhtghhrvghsqhhlrdhorhhg
X-ME-Proxy: <xmx:1E_pZrc06GaJSeKPQppNXEM2XEjJddg1a9G8vvcvwFJRXqqFRxxkEg>
    <xmx:1E_pZkOgMveAjkKk3lmK7Y1zHfNA6UBdUyAxXCmptDnPP903xaBz0g>
    <xmx:1E_pZtkKNRVX5__drp-FXTfPLUPNeorRQN34LV1pmw5jVYbkv5s3Pw>
    <xmx:1E_pZusl_k84-wUSNpd6dsI_ioSb1FDDko04UmZDthLmcPvd0fkU6Q>
    <xmx:1E_pZgAJowxbElQdx0zVP7sx5vH4PTkGEHIf8JsuiQRhZujoaEwTbnH2>
Feedback-ID: ie0a040ee:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue,
 17 Sep 2024 05:45:55 -0400 (EDT)
Message-ID: <eedaaca9-d615-4934-ab00-39ec376d9b37@eisentraut.org>
Date: Tue, 17 Sep 2024 11:45:52 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: SQL:2011 application time
From: Peter Eisentraut <peter@eisentraut.org>
To: Paul Jungwirth <pj@illuminatedcomputing.com>,
 jian he <jian.universality@gmail.com>
Cc: Isaac Morland <isaac.morland@gmail.com>,
 Robert Haas <robertmhaas@gmail.com>, Jeff Davis <pgsql@j-davis.com>,
 PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
References: <CA+renyUApHgSZF9-nd-a0+OPGharLQLO=mDHcY4_qQ0+noCUVg@mail.gmail.com>
 <58b6687fe9de002e4c862a412719e4f918bad987.camel@j-davis.com>
 <CA+Tgmob518sSV4Y8F4LN3X-7+7DmExznG1wCbYrOurfPL_xBOg@mail.gmail.com>
 <CAMsGm5duDGbSp4un6JaRn_MvujfTWCNMPSFDzJNnyW9jn-dWcA@mail.gmail.com>
 <f061295a-d972-42b9-bf1b-90a833e3f686@illuminatedcomputing.com>
 <CACJufxHPQaD+q6o_AMg1PG6ETOWC=VqzN_=6QV9C5zbR8j=Tww@mail.gmail.com>
 <b4363a52-2279-4612-8953-1100fab0c772@illuminatedcomputing.com>
 <30dc3561-d7ab-42be-a1c5-096643423590@illuminatedcomputing.com>
 <b824fc91-f534-4096-8d94-de8e21b06915@illuminatedcomputing.com>
 <73d09e24-b6b9-4c89-8c0a-8842ca0f81f9@illuminatedcomputing.com>
 <c002230c-8879-4b2c-ad05-585d6572347c@illuminatedcomputing.com>
 <CACJufxESqArbu=R8m3a+ZF-Yia26KTGpEnyqz+8d5BXb1o=c=w@mail.gmail.com>
 <CACJufxECGaLjMcN8TJbX1fGrMFKs6qu+6RiZm98=sLcpiVpu2g@mail.gmail.com>
 <081aa43c-3a97-4bd5-a498-ba02e0a7570d@illuminatedcomputing.com>
 <54390149-11d6-4f52-bbe8-f69832ceb3bd@eisentraut.org>
Content-Language: en-US
In-Reply-To: <54390149-11d6-4f52-bbe8-f69832ceb3bd@eisentraut.org>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: <https://www.postgresql.org/message-id/eedaaca9-d615-4934-ab00-39ec376d9b37%40eisentraut.org>
Precedence: bulk

On 05.09.24 14:09, Peter Eisentraut wrote:
> On 07.08.24 22:54, Paul Jungwirth wrote:
>> Here are some fixes based on outstanding feedback (some old some new). 
> 
> I have studied your patches v39-0001 through v39-0004, which correspond 
> to what had been reverted plus the new empty range check plus various 
> minor fixes.  This looks good to me now, so I propose to go ahead with 
> that.
> 
> Btw., in your 0003 you point out that this prevents using the WITHOUT 
> OVERLAPS functionality for non-range types.  But I think this could be 
> accomplished by adding an "is empty" callback as a support function or 
> something like that.  I'm not suggesting to do that here, but it might 
> be worth leaving a comment about that possibility.

I have committed these, as explained here.

I look forward to an updated patch set from you to review the "FOR 
PORTION OF" patches next.