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 1v1POv-008L4r-Qh for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Sep 2025 13:19:17 +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 1v1POu-00DHod-2Q for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Sep 2025 13:19:16 +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 1v1POt-00DHoV-P5 for pgsql-hackers@lists.postgresql.org; Wed, 24 Sep 2025 13:19:15 +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 1v1POr-002Bay-14 for pgsql-hackers@lists.postgresql.org; Wed, 24 Sep 2025 13:19:14 +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=DE4r8tfFsdJVKXLF0yZ/DWurtuwZpxZuW7zKgfGsUBY=; b=NhXTfoK9RwMdfxxuQUspjBTwPn EM97Z9wpQGTCE0SZGQ7IOPglIEAHk5FY3esBJS0BvRZP9VbsQWAKglw1Xp2JY/rZyVq3xRl6kFkuY FKAZ+FKREhYmszL7ubPJUPta/biDgb+MOw1YaKDMOJ4goaCsu6O2c+PeXbpmI2T3+ce30/o41BT+X 17IC+w7CrqQZaY46oHfJynrWcsoy5REzv9TxOT/kM85PhSoFVTVKzgLGpDGnvuPa2XIObAsG6jzot iPfnF1cODrs/c+oKQKBAHPTzBitSRhPVTxEs2Q7GAG10l81wRYSv7YARIfrr/0P7PsqCty6k31WLA D9TPGvnw==; Received: from [2409:11:4120:300:b168:5b6f:32ff:a0fd] (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 1v1POd-005VBS-0I; Wed, 24 Sep 2025 13:19:01 +0000 Date: Wed, 24 Sep 2025 22:18:42 +0900 (JST) Message-Id: <20250924.221842.203240336888394367.ishii@postgresql.org> To: ojford@gmail.com, peter@eisentraut.org Cc: 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: References: <20250917.181851.461494433278003071.ishii@postgresql.org> <20250924.143900.990623141650309126.ishii@postgresql.org> X-Mailer: Mew version 6.8 on Emacs 29.3 Mime-Version: 1.0 Content-Type: Text/Plain; charset=utf-8 Content-Transfer-Encoding: base64 X-Host-Lookup-Failed: Reverse DNS lookup failed for 2409:11:4120:300:b168:5b6f:32ff:a0fd (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGkgT2xpdmVyLA0KPiBPbiBXZWQsIFNlcCAyNCwgMjAyNSBhdCA2OjM54oCvQU0gVGF0c3VvIElz aGlpIDxpc2hpaUBwb3N0Z3Jlc3FsLm9yZz4gd3JvdGU6DQo+IA0KPj4gSSB0cmllZCB0byBjaGFu Z2UgYWxsICJpbnQgaWdub3JlX251bGxzOyIgdG8gInVpbnQ4IGlnbm9yZV9udWxsczsiIGJ1dA0K Pj4gZ2VuX25vZGVfc3VwcG9ydC5wbCBkaXNsaWtlcyBpdCBhbmQgY29tcGxhaW5zIGxpa2U6DQo+ Pg0KPj4gICBjb3VsZCBub3QgaGFuZGxlIHR5cGUgInVpbnQ4IiBpbiBzdHJ1Y3QgIkZ1bmNDYWxs IiBmaWVsZCAiaWdub3JlX251bGxzIg0KPj4NCj4+DQo+IHVpbnQ4IHdhcyBtaXNzaW5nIGluIG9u ZSBwbGFjZSBpbiB0aGF0IHBlcmwgc2NyaXB0LiBUaGUgYXR0YWNoZWQgcGF0Y2gNCj4gc2lsZW5j ZXMgaXQgZm9yIHVpbnQ4L3VpbnQxNi4NCg0KVGhhbmsgeW91IGZvciB0aGUgcGF0Y2guIChJIG5v dGljZWQgaW50OCBpcyBhbHNvIG1pc3NpbmcpLg0KDQpJIGhhdmUgbG9va2VkIGludG8gdGhlIGNv bW1pdCA5NjRkMDFhZTkwYzMgd2hpY2ggd2FzIG1hZGUgYnkgUGV0ZXIuICBJDQpoYXZlIHF1aWNr IHJlYWQgdGhyb3VnaCB0aGUgZGlzY3Vzc2lvbiB0byBrbm93IHdoeSB1aW50OC91aW50MTYgKGFu ZA0KaW50OCkgYXJlIG1pc3NpbmcgaW4gZ2VuX25vZGVfc3VwcG9ydC5wbC4gVW5mb3J0dW5hdGVs eSBJIGhhdmUgbm8NCmNsZWFyIGlkZWEgd2h5IHRoZXNlIGRhdGEgdHlwZXMgYXJlIG1pc3Npbmcg aW4gdGhlIHNjcmlwdC4NCg0KUGV0ZXIsDQpNYXliZSB5b3Ugd2FudGVkIHRvIGxpbWl0IHRoZSBk YXRhIHR5cGVzIHRoYXQgYXJlIGFjdHVhbGx5IHVzZWQgYXQNCnRoYXQgcG9pbnQ/IElmIHNvLCBw cm9iYWJseSB3ZSBzaG91bGQgb25seSBhZGQgdWludDggc3VwcG9ydCB0aGlzIHRpbWUNCih1aW50 OCBpcyBvbmx5IG5lZWRlZCB0byBpbXBsZW1lbnQgJFN1YmplY3QgZm9yIG5vdykuICBXaGF0IGRv IHlvdQ0KdGhpbms/DQoNCkJlc3QgcmVnYXJkcywNCi0tDQpUYXRzdW8gSXNoaWkNClNSQSBPU1Mg Sy5LLg0KRW5nbGlzaDogaHR0cDovL3d3dy5zcmFvc3MuY28uanAvaW5kZXhfZW4vDQpKYXBhbmVz ZTpodHRwOi8vd3d3LnNyYW9zcy5jby5qcA0K