From: | Florents Tselai <florents(dot)tselai(at)gmail(dot)com> |
---|---|
To: | "David E(dot) Wheeler" <david(at)justatheory(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter(at)eisentraut(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>, Alexander Korotkov <aekorotkov(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Andrew Dunstan <andrew(at)dunslane(dot)net> |
Subject: | Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part |
Date: | 2025-05-24 16:51:32 |
Message-ID: | 40912112-7FFE-400F-A38F-368827C4BDF1@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> On 24 May 2025, at 7:08 PM, David E. Wheeler <david(at)justatheory(dot)com> wrote:
>
> On May 23, 2025, at 13:52, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>>> I assume you mean that they’re set at initdb time, so there’s no mutability concern?
>>
>> Yeah, I think Peter's right and I'm wrong. Obviously this ties into
>> our philosophical debate about how immutable is immutable. But as
>> long as the functions only depend on locale settings that are fixed
>> at database creation, I think it's okay to consider them immutable.
>>
>> If you were, say, depending on LC_NUMERIC, it would clearly be unsafe
>> to consider that immutable, so I'm not quite sure if this is the end
>> of the discussion. But for what's mentioned in the thread title,
>> I think we only care about LC_CTYPE.
>
> Oh, so maybe all this is moot, and Florents can go ahead and add support for the functions to the non-_tz functions?
>
I think the patch is still in reasonably good shape and hasn’t changed much since September 24.
So yes, I’d hope there are still some valid points to consider or improve.
Otherwise, I’ll have only myself to blame for not pushing harder before the feature freeze. 😅
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitry Dolgov | 2025-05-24 19:20:27 | Re: Automatically sizing the IO worker pool |
Previous Message | David E. Wheeler | 2025-05-24 16:08:18 | Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part |