Re: COALESCE documentation

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Navrátil, Ondřej <onavratil(at)monetplus(dot)cz>, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: COALESCE documentation
Date: 2024-07-03 08:49:16
Message-ID: 68d8e8a5f83e51eb0feb7627bb19360956d1c684.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Peter Eisentraut 2024-07-03 09:00:17 Re: COALESCE documentation
Previous Message PG Doc comments form 2024-07-02 20:00:26 tutorial not accurate