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 1tNyxz-003KQz-Qg for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Dec 2024 18:40:16 +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 1tNyxz-000Slf-0B for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Dec 2024 18:40:14 +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 1tNyxy-000SlX-M8 for pgsql-hackers@lists.postgresql.org; Wed, 18 Dec 2024 18:40:14 +0000 Received: from mail-pf1-x42c.google.com ([2607:f8b0:4864:20::42c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tNyxs-000FOm-7L for pgsql-hackers@postgresql.org; Wed, 18 Dec 2024 18:40:13 +0000 Received: by mail-pf1-x42c.google.com with SMTP id d2e1a72fcca58-725f3594965so3384b3a.3 for ; Wed, 18 Dec 2024 10:40:08 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1734547207; x=1735152007; 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=BWyaRgR+HncMwoXie76Nv9xqVrcX0QC/6Is+JkAa8Ms=; b=RbSTYIYeJR07PCZOPzXZJIPaUxntg7dyX/fPYzHw6wyk2LAmieTZKiik//ajVCSl7H ei0FgZ0/3A7cK/h8MkZ0fV40NEvM7acMNTQCPngQWGE8rVKJ3j080VUoppSRlSZxs9Ho LnDsmOvBHJqDZqhoZyKRxsATI/SSmkALxStIUOZ3ul1+GZSZPfrJr5H3PhbtJa4zjICm 9eOFo4FmoRdsbkrPGHzXY+y8gdGC4JW2gkJn5DfKTwFxJPJlUuzJZG9Or/gdCUE2RlG6 xAsXCMYVyMPVxSo3iXnU2/gPzsqb9g/+Zu8czNcbBd201UOwReZ6Xes3LPN66Cm8cn++ ux7Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734547207; x=1735152007; 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=BWyaRgR+HncMwoXie76Nv9xqVrcX0QC/6Is+JkAa8Ms=; b=RVuHQNE7Mfbbm3DmFcGf3vwbfErD9YwGVDHwXwyE/JXorAO3b6SoNkqTGGMzDoMx08 2K8Mh/XlCLAsVOmGrqMvQ7KXMf+tJyuQYHJfs8KUje6bCx8JRJODys7gwxNqP5G3XL5M /PmlJgfakY6hLqbUHxZoNgG5M28+ICw6XVIj7Pf+VZiiR/5ndHPKWY1xEiwaF+WqlpKR +5ROaR8BDJinz85YzH7bfpnQA9gK1DN07DOcua7CRPC+G4VqK8WusBIolPu7qF7bFxLp sxAxJb/VvAfg/PlI34J4PyrKgTbZgoArxNeYmD78KtqIZSPeC4nZHzQ3gyKDFMSzQJaT yi9Q== X-Gm-Message-State: AOJu0YydyRsl5bnjJK465k34xElktWlCtvq0KR+9i7Pf1prZpsJkeyc/ u2vpiZmX1q4/gbb/JyCUQ5K/bQQo4RITiitl5pRetefsR9BZ6VpwnHyH/5sBMg== X-Gm-Gg: ASbGnctN0rcb7XcnJrUFCjlKs+JVg+Shqm1JFb17cnD0PlHEsYayc51zo6S/Nsut26C SwZesABp3UmTjYGa27NBWSGVoGBfpmNph+RW5sfI8/polIostgtJj371OOFg5esxPuQ5rPVLI5E jP7XtC68/LuRNA1OqN4OCzTVoo/CCDDH87PKQwe1zT33Bth0Tot3nI+nUCeKfxkECcTsglkXVJy 1ESGxI3w6VTGLOSGK6TEnsVo5Ajm8BzQdP8x2dI6iCtPRips10R1csmqZgoJ+GatO1kcURMnXIq ohNrqWfLhkF3mjMk6BovlZg= X-Google-Smtp-Source: AGHT+IEB4U7oNJHuXUzJgIiIYwSONGwbZnAmKDy5VyrTYYMq69CRPXvM3e6EI77ceFoUmwigQAQnkw== X-Received: by 2002:a17:90b:2e43:b0:2ee:97d1:d818 with SMTP id 98e67ed59e1d1-2f2e91a9934mr5523183a91.3.1734547207444; Wed, 18 Dec 2024 10:40:07 -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 98e67ed59e1d1-2f2ed83151bsm1906342a91.33.2024.12.18.10.40.06 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 18 Dec 2024 10:40:07 -0800 (PST) Message-ID: Subject: Re: Add CASEFOLD() function. From: Jeff Davis To: Joe Conway , Ian Lawrence Barwick Cc: pgsql-hackers@postgresql.org, Peter Eisentraut , Vik Fearing Date: Wed, 18 Dec 2024 10:40:06 -0800 In-Reply-To: <70a27f2e-3629-4fe8-8deb-4a0b987f6245@joeconway.com> References: <47716a78-eb0b-4728-8991-fc0d958a01c9@joeconway.com> <70a27f2e-3629-4fe8-8deb-4a0b987f6245@joeconway.com> 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 Mon, 2024-12-16 at 16:27 -0500, Joe Conway wrote: >=20 > SQL 2023 seems to include the NORMALIZE syntax, but the only case=20 > folding considered is UPPER and LOWER. As such, I think it ought to > be a=20 > function but not part of the grammar. Should the standard support something like the Unicode idea of case folding? If so, do we need to be careful of conflicts? Regards, Jeff Davis