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 1tbbOr-00Btxy-OZ for pgsql-hackers@arkaria.postgresql.org; Sat, 25 Jan 2025 08:20:18 +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 1tbbOp-001tX2-VC for pgsql-hackers@arkaria.postgresql.org; Sat, 25 Jan 2025 08:20:15 +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 1tbbOp-001tWu-I1 for pgsql-hackers@lists.postgresql.org; Sat, 25 Jan 2025 08:20:15 +0000 Received: from mail-pl1-x633.google.com ([2607:f8b0:4864:20::633]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tbbOk-001PUW-26 for pgsql-hackers@postgresql.org; Sat, 25 Jan 2025 08:20:14 +0000 Received: by mail-pl1-x633.google.com with SMTP id d9443c01a7336-21a7ed0155cso49157795ad.3 for ; Sat, 25 Jan 2025 00:20:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1737793209; x=1738398009; 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=oQLBEALtRdxWyGN8ffSp7G3U4zfJ/rEEzT+nJHDDn6k=; b=C/XhrzixEJRN4yJb0PQsOYvG4V22aaOgxYl8Bkkt9srLvVSSdY8o5sxEwJ5RwSZpC3 o2hCR/Eizc1KnODF3WrdOdeK6ErD+t01N0vNopwcpZD2EYHQnZ0P6G3Wl23q0b0z05ML RilMP+PyUgDDGoYIjVG4ObFbE0t+eOJPnN2riH2GrMI9xqiOgU8/FlzFkDf4DWkeoaAm 2jCQ89hAB0r5dhb7YZHBfXYSYk30QlM6S8QJLKRzQxG0hW7Rn0UD+L8ampyFr/CANJ/8 rptlQ0lde+pdPa56l6mOxFHzRCSmlOZ+Z5HEKBIVQs9ozz+uXAiGpszHob8HKf2gQosr pHVQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1737793209; x=1738398009; 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=oQLBEALtRdxWyGN8ffSp7G3U4zfJ/rEEzT+nJHDDn6k=; b=lfw77lIzxNbTzb4PD21pnxLbcaAtgYn35cOHqKyJmUph2c/5sP8S9Y6aTkd/KZHVtC 4uSxNyJ35tJrmTcrD9GkBuIqzw1EBitRStBVvS+kO6zs5wK2YddNNLbZzgm+sMrBlMKr zVFZw7WaMBvMA9WnXySxUij8UV3ytVCXbFpVZtWTt/oiWOicVPZc8bC+ryXEav5VB3Yc hy4+gHMxjW3c9amPqbXmdJNfZVPuBlvRQ2qwUxEyJCBIuUvB92cymZMkZgrSuXoRYjik PkKcN5NzdUHQ+NxopDiOQt1MpPpeIbWH02hrU3OYtpksr4uN8umfwHWBz0gjtoD0p5fJ 6+pA== X-Forwarded-Encrypted: i=1; AJvYcCV2zMxVS0BsG7X1gHA/+P8apqxRJhYPj0E5ZVKFQSCUXrTlqnfyfnWK4Acd9wHJm1Fln0mWuU34fHjiR3l7@postgresql.org X-Gm-Message-State: AOJu0YySCenKR32xFnyLdy6/gq2mcOlIZvaYfT3rnAhVacPSnQMokwrS 5QroKirEQsNLBWvySPrLkt4z6N7msTZkYPk62STYJzGkznISX5uIUOGyZsfH1w== X-Gm-Gg: ASbGncsq9F2SmdS6qugYHSuUETyYMtQywScuwe7JIUyI3lziIcITismWecdEu+JWw+O z5nd+gN6b2ZUgyN81LlgGIe+TTmWRQbCtE59zkguMnGWjGTDqMFSMo7KEJR0HMGggc3Gwx95QM9 1imzFIqRVsBm4RurjCQSj79n7ZfRTghU53LlfXkw4uwC2Ov5zTUFA/52sdx/deigPK+UnG7j9R1 G5gqy6ShFrV7Rds6n19ScDZ3DOtDFIBfsXV+QB52H3ngFOmlqonohsvxu7zJHLz/9J//b4eaFx5 TAubz11c63fn2NdviiOY1v3G4G4SXNAqhtex0nx5HwBsEyn2+nS75GTPQA== X-Google-Smtp-Source: AGHT+IHQ+L8k3TEre9Dab28XIyVj1MUPpHvb6ZR0Bhp8RHH1b76zVE10kKrHtCNehjlN1iGR7dt0ag== X-Received: by 2002:a17:902:e80f:b0:215:8dd3:536a with SMTP id d9443c01a7336-21c352ddfc1mr521093705ad.4.1737793208930; Sat, 25 Jan 2025 00:20:08 -0800 (PST) Received: from jeff-laptop.lan (c-76-102-242-158.hsd1.ca.comcast.net. [76.102.242.158]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-21da424ef28sm27626925ad.258.2025.01.25.00.20.08 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 25 Jan 2025 00:20:08 -0800 (PST) Message-ID: Subject: Re: Add CASEFOLD() function. From: Jeff Davis To: Tom Lane Cc: Peter Eisentraut , Joe Conway , Ian Lawrence Barwick , pgsql-hackers@postgresql.org Date: Sat, 25 Jan 2025 00:20:06 -0800 In-Reply-To: <608525.1737781222@sss.pgh.pa.us> References: <47716a78-eb0b-4728-8991-fc0d958a01c9@joeconway.com> <8c384b0d-00f2-4515-8e60-ff7d0d4c093a@eisentraut.org> <898752524b1ad658c5fdae789f823a0dc52e6171.camel@j-davis.com> <610a56de2bd958e96c149ca60420db30e7d51588.camel@j-davis.com> <7134f83a3242a1f04cf91c259ec98ecfe56367ed.camel@j-davis.com> <608525.1737781222@sss.pgh.pa.us> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu2 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, 2025-01-25 at 00:00 -0500, Tom Lane wrote: > Found characters that cannot be output in the PDF document;=C2=A0 see > README.non-ASCII Thank you, fixed. > Not sure about a good workaround for this.=C2=A0 Are there any characters > within LATIN-1 that have interesting case-folding behavior? I just removed that example. There's already another example using =C3=9F (U+00DF), though that only applies to PG_UNICODE_FAST (the new collation that performs full case mapping and now full case folding). Regards, Jeff Davis