On Tue, 2024-07-02 at 12:45 +0200, Navrátil, Ondřej wrote: > as per documentation > > The COALESCE function returns the first of its arguments that is not null. > > Null is returned only if all arguments are null. > > This is not exactly true. In fact: > The COALESCE function returns the first of its arguments that is distinct > from null. Null is returned only if all arguments are not distinct from null.
+1 Do you want to write a documentation patch? Yours, Laurenz Albe