Andrew Dunstan <> writes:
>> Is there any particular reason extract functions
>> (object_field/array_element/...) can't be immutable?
>> I can't readily imagine a situation where output of these functions would
>> change for different queries.

> Me either. It's an oversight, really. Unless there is any objection I'll 
> change them toot sweet. What about the existing (as of 9.2) functions?

Note that anything that invokes other types' I/O functions can't be
immutable, at most stable.  But the ones that don't do that certainly
should be fixed.

BTW, while I'm looking at this: json_populate_record and
json_populate_recordset are marked as non-strict, but they are
completely broken for null inputs because they attempt to fetch inputs
before checking them for null-ness.

                        regards, tom lane

Sent via pgsql-hackers mailing list (
To make changes to your subscription:

Reply via email to