Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part
Date
Msg-id 7e9debe6-4e96-4b0d-a801-b531e962ef43@eisentraut.org
Whole thread Raw
In response to Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part
List pgsql-hackers
On 09.05.25 21:50, Robert Haas wrote:
> I always struggle a bit to remember our policy on these issues -- to
> the best of my knowledge, we haven't documented it anywhere, and I
> think we probably should. I believe the way it works is that whenever
> a function depends on the operating system's timestamp or locale
> definitions, we decide it has to be stable, not immutable. We don't
> expect those things to be updated very often, but we know sometimes
> they do get updated.

I don't understand how this discussion got to the conclusion that 
functions that depend on the locale cannot be immutable.  Note that the 
top-level functions lower, upper, and initcap themselves are immutable.




pgsql-hackers by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: [Util] Warn and Remove Invalid GUCs
Next
From: Melanie Plageman
Date:
Subject: Re: Log connection establishment timings