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 1v8cA0-003rBB-6R for pgsql-hackers@arkaria.postgresql.org; Tue, 14 Oct 2025 10:21: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 ) id 1v8c9x-00COuY-Ud for pgsql-hackers@arkaria.postgresql.org; Tue, 14 Oct 2025 10:21:38 +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 ) id 1v8c9x-00COuQ-L7 for pgsql-hackers@lists.postgresql.org; Tue, 14 Oct 2025 10:21:38 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v8c9w-0026GT-0i for pgsql-hackers@lists.postgresql.org; Tue, 14 Oct 2025 10:21: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=+/2q0Id1oEAM7t9GXlbOrJaj3/pTao5Bdm3y9PQIHsk=; b=TJjq2ZWRrNrXdFfLFamveJnRRv +61gWE6lfcEHLYa/cd8qy7c5wVvJDGslU2V1owMmoKYZAEuZEVme4wOHMtZ4btVjo/JuM94CMcvx2 Vz4vsb7CHuJXZZJbhpTYGdAbtnyPk7rFyWbBhY7iNobL+dgqoLVj9q9PYUggvGk0zhiaVMksXAWDv REyE6lYtUWYQiOGZsZRr3rSF19gyXOx0rky6AmqKkSBclL8qlOOW246Y588Dus1N53FQRkYCbHY4/ JpYSQtcj/ZoyIa7p07oSjV2xHgddmqk0vBFwaCyFpvc1xqp3VQHnn9ikZyjCY9xiOPAreqInC+qfI YMRPMokw==; Received: from [2409:11:4120:300:e345:4e99:291:342] (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 1v8c9o-005S9X-1d; Tue, 14 Oct 2025 10:21:30 +0000 Date: Tue, 14 Oct 2025 19:21:13 +0900 (JST) Message-Id: <20251014.192113.1554227757626092006.ishii@postgresql.org> To: li.evan.chao@gmail.com Cc: tgl@sss.pgh.pa.us, pramsey@cleverelephant.ca, ojford@gmail.com, peter@eisentraut.org, 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 In-Reply-To: <20251013.143941.1447453701514209859.ishii@postgresql.org> References: <20251011.144218.1729318385118014326.ishii@postgresql.org> <66A28678-BDC0-4266-9244-74320D578222@gmail.com> <20251013.143941.1447453701514209859.ishii@postgresql.org> X-Mailer: Mew version 6.8 on Emacs 29.3 Mime-Version: 1.0 Content-Type: Text/Plain; charset=iso-2022-jp Content-Transfer-Encoding: 7bit X-Host-Lookup-Failed: Reverse DNS lookup failed for 2409:11:4120:300:e345:4e99:291:342 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk >>>> I overlooked the elog() call and "own implementation of >>>> get_func_name()". Will fix. >>> >>> Attached is a trivial patch to fix that. I am going to push it if >>> there's no objection. >>> >>> Best regards, >>> -- >>> Tatsuo Ishii >>> SRA OSS K.K. >>> English: http://www.sraoss.co.jp/index_en/ >>> Japanese:http://www.sraoss.co.jp >>> >> >> >> I just take a quick look at the patch, a tiny comment is: >> >> ``` >> + char *funcname = get_func_name(fcinfo->flinfo->fn_oid); >> ``` >> >> This can be a “const char *”. > > Thanks for the review. In addition to the point, I added an assertion > which is called by all other window function API. Also added check to > the return value of get_func_name() because it could return NULL. V2 > patch attached. V2 patch pushed. Thanks. Best regards, -- Tatsuo Ishii SRA OSS K.K. English: http://www.sraoss.co.jp/index_en/ Japanese:http://www.sraoss.co.jp