Re: Assert single row returning SQL-standard functions

On Fri, Aug 29, 2025, at 19:27, Pavel Stehule wrote:
> pá 29. 8. 2025 v 18:51 odesílatel Joel Jacobson <joel(at)compiler(dot)org> napsal:
>> In the meantime, maybe we want to add a catalog function
>> nonnull(anyelement) -> anyelement that throws an error if the input is
>> NULL? Seems like a function that could be useful in general.
>> Attached a small patch that adds such a function.
>
> +1

New version attached. Added docs and tests. Wasn't sure where to put the
docs. It's kinda a comparison function, since we compare against NULL
internally? I put the docs in func-comparison.sgml, please advise if
some other file would be better.

> Orafce introduces https://github.com/orafce/orafce:
>
> PLUnit
>
> <https://github.com/orafce/orafce#plunit>
> This unit contains some assert functions.

Nice, that looks like an impressive collection of lots of useful
functions, thanks, will check it out.

/Joel