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 ) id 1v6HS9-0025kv-8n for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Oct 2025 23:50:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1v6HS5-00581G-Hv for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Oct 2025 23:50:42 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v6HS5-0057zs-7z for pgsql-hackers@lists.postgresql.org; Tue, 07 Oct 2025 23:50:42 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v6HS2-000ZhG-0b for pgsql-hackers@lists.postgresql.org; Tue, 07 Oct 2025 23:50:41 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Transfer-Encoding:Content-Type: Mime-Version:References:In-Reply-To:From:Subject:Cc:To:Message-Id:Date:Sender :Reply-To:Content-ID:Content-Description; bh=VMBSuqSt4FRj/2iaWbOd0mFkqiN8fkdI8cPJSwnLzJQ=; b=aF9NFo/4O/C9OiHKzqSbTqVAyO V3JrGjBhRrQD7JcGuWc9B4yIFZ4gM/tBmB3tLtG5HfL3oxXURquvKuitI1KxTV91tWP6VCa7tu409 euNn4NQDNqDCQxxAm7G8TH3E5o1L+XI71v0M3pLCeZZOKX7BiDo7ZkReYVcKscPAixttejhHp1gU9 ItsDndD0l6m556TVE0K+lWXdXVuFpNMImg3xHOO6f8auEH1Aos7XXy/gRXrFhhLALMkoJhBQ9UE8w HMDUVHVbI6cg53S5fm7pbCwNocDYeTgRvlOncfuELynXWTQyutQagY+NNprGzRonQp4S92eiX+6oe mDTsPjiw==; Received: from [2409:11:4120:300:bd0d:5ede:9bda:9317] (helo=localhost) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v6HRu-002dYE-0a; Tue, 07 Oct 2025 23:50:32 +0000 Date: Wed, 08 Oct 2025 08:50:16 +0900 (JST) Message-Id: <20251008.085016.1771833814329805825.ishii@postgresql.org> To: alvherre@kurilemu.de Cc: ojford@gmail.com, peter@eisentraut.org, li.evan.chao@gmail.com, krasiyan@gmail.com, tgl@sss.pgh.pa.us, vik@postgresfriends.org, andrew@tao11.riddles.org.uk, david@fetter.org, pgsql-hackers@lists.postgresql.org Subject: Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options From: Tatsuo Ishii In-Reply-To: <202510051612.gw67jlc2iqpw@alvherre.pgsql> References: <20251003.100606.2086363717963832725.ishii@postgresql.org> <202510051612.gw67jlc2iqpw@alvherre.pgsql> X-Mailer: Mew version 6.8 on Emacs 29.3 Mime-Version: 1.0 Content-Type: Text/Plain; charset=iso-8859-7 Content-Transfer-Encoding: base64 X-Host-Lookup-Failed: Reverse DNS lookup failed for 2409:11:4120:300:bd0d:5ede:9bda:9317 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PiBJIGp1c3Qgbm90aWNlZCB0aGlzIGNvbXBpbGVyIHdhcm5pbmcgaW4gYSBDSSBydW4sDQo+IA0K PiBbMTY6MDY6MjkuOTIwXSAuLi9zcmMvYmFja2VuZC9leGVjdXRvci9ub2RlV2luZG93QWdnLmM6 MzgyMDoxNjogd2FybmluZzogoWRhdHVtoiBtYXkgYmUgdXNlZCB1bmluaXRpYWxpemVkIFstV21h eWJlLXVuaW5pdGlhbGl6ZWRdDQo+IFsxNjowNjoyOS45MjBdICAzODIwIHwgICAgICAgICByZXR1 cm4gZGF0dW07DQo+IFsxNjowNjoyOS45MjBdICAgICAgIHwgICAgICAgICAgICAgICAgXn5+fn4N Cj4gWzE2OjA2OjI5LjkyMF0gLi4vc3JjL2JhY2tlbmQvZXhlY3V0b3Ivbm9kZVdpbmRvd0FnZy5j OjM3MTk6MjU6IG5vdGU6IKFkYXR1baIgd2FzIGRlY2xhcmVkIGhlcmUNCj4gWzE2OjA2OjI5Ljky MF0gIDM3MTkgfCAgICAgICAgIERhdHVtICAgICAgICAgICBkYXR1bTsNCj4gWzE2OjA2OjI5Ljky MF0gICAgICAgfCAgICAgICAgICAgICAgICAgICAgICAgICBefn5+fg0KPiANCj4gVGhlIGxvZ2lj IGluIHRoaXMgZnVuY3Rpb24gbG9va3Mgc29tZXdoYXQgd2lja2VkLg0KDQpUaGFua3MgZm9yIHRo ZSByZXBvcnQuIEkgYmVsaWV2ZSB0aGUgd2FybmluZyBpcyBlbGltaW5hdGVkIGluIHRoZSB2Mg0K cGF0Y2hbMV0uDQoNCkJlc3QgcmVnYXJkcywNCg0KWzFdIGh0dHBzOi8vd3d3LnBvc3RncmVzcWwu b3JnL21lc3NhZ2UtaWQvMjAyNTEwMDcuMTEyODMyLjc0MDA2NTc2OTA4OTMyODA0MS5pc2hpaSU0 MHBvc3RncmVzcWwub3JnDQotLQ0KVGF0c3VvIElzaGlpDQpTUkEgT1NTIEsuSy4NCkVuZ2xpc2g6 IGh0dHA6Ly93d3cuc3Jhb3NzLmNvLmpwL2luZGV4X2VuLw0KSmFwYW5lc2U6aHR0cDovL3d3dy5z cmFvc3MuY28uanANCg==