Re: [PATCH] Add error_on_null() to produce an error if the input is null

On Sat, Aug 30, 2025, at 18:38, Tom Lane wrote:
> Vik Fearing <vik(at)postgresfriends(dot)org> writes:
>> On 30/08/2025 13:49, Joel Jacobson wrote:
>>> This polymorphic function produces an error if the input value is null,
>>> otherwise it returns the input value unchanged.
>
>> This only checks for the null value. I don't think we need to change
>> the function's name, but we do need to be more precise in the
>> documentation that it checks for the null value and not values that are
>> null.
>
> Agreed. You might be able to borrow some wording from the docs'
> discussion of the IS [NOT] NULL construct, and/or IS DISTINCT FROM.
>
> regards, tom lane

Thanks for great feedback. New patch attached.

/Joel