Re: [18] Policy on IMMUTABLE functions and Unicode updates - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [18] Policy on IMMUTABLE functions and Unicode updates
Date
Msg-id CA+TgmoYbK3u4LMHaEuLp0y_XDU6OgN65K7enw9=BdmbN=OxMSQ@mail.gmail.com
Whole thread Raw
In response to Re: [18] Policy on IMMUTABLE functions and Unicode updates  (Jeremy Schneider <schneider@ardentperf.com>)
List pgsql-hackers
On Wed, Jul 24, 2024 at 3:43 PM Jeremy Schneider
<schneider@ardentperf.com> wrote:
> But non-unique indexes for case insensitive searches will be more common. Historically this is the most common way
peopledid case insensitive on oracle. 
>
> Changing ctype would mean these queries can return wrong results

Yeah. I mentioned earlier that I very recently saw a customer query
with UPPER() in the join condition. If someone is doing foo JOIN bar
ON upper(foo.x) = upper(bar.x), it is not unlikely that one or both of
those expressions are indexed. Not guaranteed, of course, but very
plausible.

--
Robert Haas
EDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Jeremy Schneider
Date:
Subject: Re: [18] Policy on IMMUTABLE functions and Unicode updates
Next
From: Andreas Karlsson
Date:
Subject: Re: Convert sepgsql tests to TAP