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 1uSGbc-005SiF-LC for pgsql-hackers@arkaria.postgresql.org; Thu, 19 Jun 2025 14:51:08 +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 1uSGba-00C1qP-ON for pgsql-hackers@arkaria.postgresql.org; Thu, 19 Jun 2025 14:51:07 +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 1uSGba-00C1qH-F9 for pgsql-hackers@lists.postgresql.org; Thu, 19 Jun 2025 14:51:07 +0000 Received: from fout-a1-smtp.messagingengine.com ([103.168.172.144]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1uSGbZ-002uDq-0F for pgsql-hackers@postgresql.org; Thu, 19 Jun 2025 14:51:06 +0000 Received: from phl-compute-03.internal (phl-compute-03.phl.internal [10.202.2.43]) by mailfout.phl.internal (Postfix) with ESMTP id 88D2A1380652; Thu, 19 Jun 2025 10:51:04 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-03.internal (MEProxy); Thu, 19 Jun 2025 10:51:04 -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=1750344664; x=1750431064; bh=xPGdD6VCPwNGWu/UMmCCmIeO4MZp9s81 cDytZdmM3tQ=; b=YgPhFZQSZuMkD2rI0n51YiWXZM1dlHlbmFAmeINkO20+4atp sUro6T8aW5rDKpzJcL8YyjuvvyVFq+22jM/boGSHhIUM+9KH+zf1y9Lal1F3J6rE j/eXNpdkwgdBk1GsjL0wwhnnSrLapzgcSwn0CLrSSQ1IDGzspWUhkWbZGc0EPTkb nSnSIDI7h3S7ojIMayHs272J3Wja2odxPYwfxKKx+GQWK5XxwsvHHAWh6rqW4xL+ 9G8yYgxkJ1Ce0X9aKQuVUGwo7KGNOHNfGEW4lCUAfcIL28SLUE06GjsKIfVi8z3h bSazCMLpI4u4c6/ClCUNOfyqv7q+7iS8Hba0eg== 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-sender:x-me-sender:x-sasl-enc; s=fm1; t=1750344664; x= 1750431064; bh=xPGdD6VCPwNGWu/UMmCCmIeO4MZp9s81cDytZdmM3tQ=; b=G hplTmPPr4oYRgLzJHn9pr95vaJ7ctwsHCQCfvaWM7nsXUzRf/KhrxiPh0X5M+zrB RmBZGJZxxQUZWQjj+pUrplvCXLLybgO4vdxKZgSNglbW0KTkEXdGmBbIu4tzNr4M njGjmEQrsuVb7tc4tvaTPW+lrv1Cx8/0dTcQ6dh6CCxvzzshRFul45ly6Qa/l0Ff Y+ibbE8Vb8H3u6sL0dAbEut5yQ8s87VZYpNz+z7WfxiZTsAcUeOsJY4UrGEXbRVr 6xw0NJEPfYZxSHKsoVSYfJGbBem+CGY/jAl1wPvtuDiMIu2kuLSF1SsPqE8K00Xi G9eifOuAMfzj44IFWn7xA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtddvgdehkeduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceurghi lhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujfgurh epkfffgggfuffvvehfhfgjtgfgsehtjeertddtvdejnecuhfhrohhmpefrvghtvghrucfg ihhsvghnthhrrghuthcuoehpvghtvghrsegvihhsvghnthhrrghuthdrohhrgheqnecugg ftrfgrthhtvghrnhepgfejtdfhkeeftdeugfeileehteeljeeghfeuledthfeutedvffdu keefjefhgeehnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrh homhepphgvthgvrhesvghishgvnhhtrhgruhhtrdhorhhgpdhnsggprhgtphhtthhopeei pdhmohguvgepshhmthhpohhuthdprhgtphhtthhopehthhhomheslhhinhhugidrtghomh dprhgtphhtthhopehpghhsqhhlsehjqdgurghvihhsrdgtohhmpdhrtghpthhtohepvhhi khesphhoshhtghhrvghsfhhrihgvnhgushdrohhrghdprhgtphhtthhopehmrghilhesjh hovggtohhnfigrhidrtghomhdprhgtphhtthhopegsrghrfihitghksehgmhgrihhlrdgt ohhmpdhrtghpthhtohepphhgshhqlhdqhhgrtghkvghrshesphhoshhtghhrvghsqhhlrd horhhg X-ME-Proxy: Feedback-ID: ie0a040ee:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 19 Jun 2025 10:51:03 -0400 (EDT) Message-ID: Date: Thu, 19 Jun 2025 16:51:02 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Add CASEFOLD() function. To: Thom Brown , Jeff Davis Cc: Vik Fearing , Joe Conway , Ian Lawrence Barwick , PostgreSQL-development References: <47716a78-eb0b-4728-8991-fc0d958a01c9@joeconway.com> <36f69fa9-db3f-44a1-8c8a-95ff09704a9c@postgresfriends.org> <692d28a2-d5f8-4db5-a3ad-c7db9bab522f@postgresfriends.org> Content-Language: en-US From: Peter Eisentraut In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 19.06.25 06:03, Thom Brown wrote: > Late to the party, but is there an argument for porting this to the > citext type? Or supplementing the extension with an additional type > ("cftext"? *shrug*). It currently uses lower(), so our current > recommendation for dealing with all unicode characters is to use > nondeterministic collations. What is the motivation for wanting a citext variant instead of using nondeterministic collations?