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 1tLnx2-00H8eZ-0V for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Dec 2024 18:30: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 1tLnwy-00DsOa-Oo for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Dec 2024 18:30:13 +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 1tLnwy-00DsOR-DO for pgsql-hackers@lists.postgresql.org; Thu, 12 Dec 2024 18:30:13 +0000 Received: from mail-pf1-x435.google.com ([2607:f8b0:4864:20::435]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tLnws-002UP5-R3 for pgsql-hackers@postgresql.org; Thu, 12 Dec 2024 18:30:12 +0000 Received: by mail-pf1-x435.google.com with SMTP id d2e1a72fcca58-728e1799d95so1080562b3a.2 for ; Thu, 12 Dec 2024 10:30:06 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1734028206; x=1734633006; 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=kruBakTPkCExC/T/RKrks1OummdOcAdqwV5My6LHuiU=; b=HOZD8bwSXkUPpk/mPLKjjVmWysnY1r2zH1VxcKyeut16qagz6KmZxBaye8XlG+MQcW OjHqfUxXEpUhEz2Id6Q1uSeCs8dJ1bSJytICME6w4zbBlPYtQf0c1L+rtT6IQiY/w5iX FqYAqRISzBiV0pVfIyI6ieObQ6xc8N1osownVtdAORoH9A9syM3inqXczatVuhwOIDbl H9w65TQloP8Y81PGNCPfOMmvAERo3KSSC/mflCU9lWUx/O2dtJxjxBbkrxVd5fm5ySEG e9vRT9AIyXQXma7ZlrWrFcdleZCiaWMt+0Oln7vCGbE7xdGHyJdrYDFk69SZ8UCMEiRf CscQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734028206; x=1734633006; 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=kruBakTPkCExC/T/RKrks1OummdOcAdqwV5My6LHuiU=; b=Acfj/uKCOmqceWOJ+UzY84RJ0AdgvoEkSs4uVoaHigpVLZyrposhbbOAGq/+DVB6CT //lXRVnuRF9MnxwO8Znal+1ACcfBrWcz4rzNNp/EcDwwWb9b4jwMtVYPWB9TuSIvh+sN y75+Kkdqw8Htm9znyb+m7i6pQ5leRDKkzcZp3L1+2zxR0M+4e7bp0rrhsmcs39czWicn OTzMaq31oEUAUdocmnoDJTYyi10ULgxS+RZ5M4uX4wLwBiMXGYjpLXWvgtvHdAPoWNtI s1aYT72Y818+B1mON4nn7c5VkaAFgfexjUIobCfmFGkioPGVuLnA6ZFzjJPD+AkszyU4 LfXQ== X-Gm-Message-State: AOJu0Yz446RzfvR7D0w7zylrQyjICgdoQSOYccXt0GIkvVz+VZnOipzw +u3ajfHWuoat34JQJaEo18D/iH1NlJ8IDRAem4wfgvHKIkwWiuppt9hGFb9VgQ== X-Gm-Gg: ASbGnctm0Fp74h2C4R3JsA/68N3SkS5KSWmXsL+s+tGplvZ9zxdGSY6iRyowYGSTEt/ oYP07AB9xNgDLdT1MlI3Q8QZNEAP6w+MCjXFPPnQrfbQPu4xgOhmWLVu/05hJet8AbuebF73hL5 LRawGup08ug604+lNPmTFPdyWiqZ5su3teKUKbTjLOrcj8RxylEZKmOYo8m6PMclK03sPmYY46l Hrk+C9IAU1teMRdVErDOdrWeyJYsOZtQFiw+rZGAXE4SrqMLeQKuMRij/vEY56BjFqVLGA+4nQD BUez0I/hveOh5Gt9MetxGQk= X-Google-Smtp-Source: AGHT+IFXkL2QPY+/GgALq1ldMsxmyDQQLvvk0b8IS4E7lt1tdpNFOQE3qDCcADXopzSZ518t5BtzUg== X-Received: by 2002:a05:6a20:4321:b0:1dc:2a02:913b with SMTP id adf61e73a8af0-1e1dab40849mr2182366637.15.1734028205783; Thu, 12 Dec 2024 10:30:05 -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 d2e1a72fcca58-725d30e6959sm9683265b3a.88.2024.12.12.10.30.04 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 12 Dec 2024 10:30:05 -0800 (PST) Message-ID: Subject: Re: Add CASEFOLD() function. From: Jeff Davis To: Ian Lawrence Barwick Cc: pgsql-hackers@postgresql.org Date: Thu, 12 Dec 2024 10:30:04 -0800 In-Reply-To: References: 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 Thu, 2024-12-12 at 21:52 +0900, Ian Lawrence Barwick wrote: > and it seems to work as advertised, except the function is named > "FOLDCASE()" > in the patch, so I'm wondering which is intended? Thank you for looking into this, I went back and forth on the name, and mistyped it a few times. ICU seems to use "foldcase": https://unicode-org.github.io/icu-docs/apidoc/dev/icu4c/ucasemap_8h.html and it seems to be slightly more proper grammatically (with "fold" being the verb). However, "case folding" is common terminology in Postgres and Unicode, so "casefold" can be seen as the verb instead. I don't have a strong opinion here so I will just go with whatever seems like the popular choice. Regards, Jeff Davis