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 1v6I5k-002FVe-MY
	for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Oct 2025 00:31:40 +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 1v6I5i-005Wji-Gc
	for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Oct 2025 00:31:39 +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 <ishii@postgresql.org>)
	id 1v6I5i-005WjI-6k
	for pgsql-hackers@lists.postgresql.org; Wed, 08 Oct 2025 00:31:39 +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 <ishii@postgresql.org>)
	id 1v6I5f-000a08-38
	for pgsql-hackers@lists.postgresql.org;
	Wed, 08 Oct 2025 00:31:38 +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=m/rIacF0HpseKziP5SF/AF5DXQ9QrYh+PPhWyC8AxE8=; b=cCBygx2WafV78E0kHJY2wtHJGU
	RHdgnZznWRg5FHbIk/GxwkpAij2IFgC3Yyulz6xfk+Mv42QtTM1LI26Hg/ZB3B88b4xhifj3PbGqM
	z/fh4PiqAcZ6Wm/yqmVjL5DU88la7wORGcm/6RjkD8Y2gYvf/QvvIYjDAkfM20ajVSJyKVxydtrxQ
	1ia5UeLcqsVNNDa8lu18h8iA5Yig7sz1uuABcUXEr9v1G48hI96m0P0BbdMtoEzpqr/yZ2JwHYiPR
	ADxbEQSIkX5lzA3KyxvY3EprKL9+dKWJqnzSb1p087Prg+LfqLprQLBMrOp6eSBtiTZsQb6ogjDY9
	z7cijOpw==;
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 <ishii@postgresql.org>)
	id 1v6I5Y-002eJJ-2c;
	Wed, 08 Oct 2025 00:31:30 +0000
Date: Wed, 08 Oct 2025 09:31:17 +0900 (JST)
Message-Id: <20251008.093117.1326499841464447981.ishii@postgresql.org>
To: pramsey@cleverelephant.ca
Cc: tgl@sss.pgh.pa.us, ojford@gmail.com, peter@eisentraut.org,
 li.evan.chao@gmail.com, krasiyan@gmail.com, 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 <ishii@postgresql.org>
In-Reply-To: 
 <CACowWR0t-xgqtwrzW1LipyqXennDUnV3d0qysVHJghBiWZ3HWg@mail.gmail.com>
References: <20251006.183439.876014721998277138.ishii@postgresql.org>
	<20251007.112832.740065769089328041.ishii@postgresql.org>
	<CACowWR0t-xgqtwrzW1LipyqXennDUnV3d0qysVHJghBiWZ3HWg@mail.gmail.com>
X-Mailer: Mew version 6.8 on Emacs 29.3
Mime-Version: 1.0
Content-Type: Text/Plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Host-Lookup-Failed: Reverse DNS lookup failed for
 2409:11:4120:300:bd0d:5ede:9bda:9317 (failed)
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/20251008.093117.1326499841464447981.ishii%40postgresql.org>
Precedence: bulk

>> Attached is the v2 patch.
>>
> 
> Thanks! This passes regression, and reads right to my eye and (most
> important to me) allows PostGIS to run under Pg19 again.

Thank you for the review! I have just pushed the v2 patch.

Best regards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp