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 1uS6rA-003TA0-NP for pgsql-hackers@arkaria.postgresql.org; Thu, 19 Jun 2025 04:26:33 +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 1uS6r8-007P0Y-H4 for pgsql-hackers@arkaria.postgresql.org; Thu, 19 Jun 2025 04:26:31 +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 1uS6r8-007P0Q-2i for pgsql-hackers@lists.postgresql.org; Thu, 19 Jun 2025 04:26:30 +0000 Received: from mail-pl1-x62e.google.com ([2607:f8b0:4864:20::62e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uS6r6-002sR0-0T for pgsql-hackers@postgresql.org; Thu, 19 Jun 2025 04:26:30 +0000 Received: by mail-pl1-x62e.google.com with SMTP id d9443c01a7336-2349f096605so6079365ad.3 for ; Wed, 18 Jun 2025 21:26:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1750307185; x=1750911985; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=2m6Dzj6Ri1WeT/Fx9Z/mGOvAkiykRR9x6wL/u0AbR8M=; b=HoAY4aq0h0ZwKBHcMbc6v6azgnNdZjBvApiZOx4rbzkSS2DXJiUthX9RnKYM+49Ag7 1oxS2+79ng6xpAg8XljfWGo1w52GmV00++uj5wnzwfEi1zdVjAUtEPlIkjvtLmorUA+Z HMUTDDPfl7cOpVHOhb9RVkYBow2RbSBl5sbpMunmy3VflSW9QPL+GwSafLE0pVeZngXH 5fr07e4UFfFLCWEjFfSfiUt1noLDufdegpceMmu1SF8rGOAdkVzalVLOjy9shGZWWSqr xehAEpk3tAeaAjFfLbpbnvpNgZBer8aQN1iGUTgKdPrZixFKrJRw4FVYnESfUgluFIG6 JY+Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1750307185; x=1750911985; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=2m6Dzj6Ri1WeT/Fx9Z/mGOvAkiykRR9x6wL/u0AbR8M=; b=AalG4NjwXC2e9jvnWOEz0QZladZGNseJ1P5Sk3uBnJd/NWi4bI6TrWs4naQKyKX8Xo opMRWW7Q6UVRVGOOULXsW/1VWyJ/cABC6LsKzbDLLTVQ65kuYn2Iu4bF6V7XWZQ+qWKc gwpLKeu3RRLRx6pW3bfiArymhPbri6xghyzIA/E0TckhONCvIWWecxqtlXyIXsreOUdK UbB37K8vMXBVIu7Cu5sLIxYHrCZ8EHAEGL0ULRvXqUL6YrSP/3XQEAOLGOmlDInWk8U9 G03qDoSe4/VD35tA0blwUJiKbnb5XrhM2dHOC2QGVVZnXQD+wkGspUZOt4iHCxBJfRso wkqg== X-Forwarded-Encrypted: i=1; AJvYcCXVv90QfMd3KETYvQti63JzSrBtg+15SFwFJLqqIMFzv1BKMrwyikXk9GpJve4dkrnEY0mtW5bl00kCuECb@postgresql.org X-Gm-Message-State: AOJu0YzV6GPUnldL54rQ2VYd3mYtV5dVSE/qKY1Hw6qbmnxTJHJcOI94 CSjYoBAc5cDRxlt79uXxGwwo19qpqZ1eDB9ciogUcUtBs3EdDcqCInCU7vrHJbQxRg== X-Gm-Gg: ASbGncuFZaCsNdyD6YPaFzmgtng9jyCfKfDQK/DIgBVnuvUlbzNGcHa4uglCRc6kAJD 69YcB8NOGxfIHCD1AQ5pSErcAY3Ht6oXjDWf+o1CUNPdQJey2cMEo66BFPjsUBJkXaFs2nxuW+E GeqdkJVXQnb1AHhtPSxG/JikzVf1yR0mCyRSkq1OwKzJoxmPPSNqJ4WhKj9+AD3rfMzAkhpDBFg JWU3PpNLiTSpOVvyTjg4e8QziXGGEQ8hvxtXvQVB0NWBA2Pcy/GHfuRG7ULRszD6V5GwvG+sSCs RmfBpzmWR0+c+SpzbURuNLUbo6PuRhnQNdEcuAsmMcG8OW2SDGXCFmAAxBvqGP3C8QpZLmBg9in TBnQuziDW1Fqc0C3jPp5s2KFio4buxyFa X-Google-Smtp-Source: AGHT+IHtpbTo9/Kk4scggDhUj+D7e4iJ4KY92E20CtC3eoiArGoPB/tnGq8TiZOyIpYi9nw/TOlQbQ== X-Received: by 2002:a17:903:40cf:b0:235:e96b:191c with SMTP id d9443c01a7336-2366b3ac2e0mr317255615ad.29.1750307185568; Wed, 18 Jun 2025 21:26:25 -0700 (PDT) Received: from jeff-ws-bridge.lan (c-76-102-242-158.hsd1.ca.comcast.net. [76.102.242.158]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-2365d88bef8sm110704185ad.30.2025.06.18.21.26.24 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 18 Jun 2025 21:26:25 -0700 (PDT) Message-ID: Subject: Re: Add CASEFOLD() function. From: Jeff Davis To: Thom Brown Cc: Vik Fearing , Joe Conway , Ian Lawrence Barwick , PostgreSQL-development , Peter Eisentraut Date: Wed, 18 Jun 2025 21:26:23 -0700 In-Reply-To: References: <47716a78-eb0b-4728-8991-fc0d958a01c9@joeconway.com> <36f69fa9-db3f-44a1-8c8a-95ff09704a9c@postgresfriends.org> <692d28a2-d5f8-4db5-a3ad-c7db9bab522f@postgresfriends.org> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.52.3-0ubuntu1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2025-06-19 at 05:03 +0100, 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*). CASEFOLD() addresses a lot of the problems with using LOWER(), so that sounds like a good idea. I'd be interested to hear from users of citext. Regards, Jeff Davis