Re: COALESCE documentation

On 02.07.24 12:45, Navrátil, Ondřej wrote:
> Hello,
> 
> as per documentation 
> <https://www.postgresql.org/docs/current/functions-conditional.html#FUNCTIONS-COALESCE-NVL-IFNULL>
>  > 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.
> 
> See my stack overflow question here 
> <https://stackoverflow.com/questions/78691097/postgres-null-on-composite-types>.
> 
> Long story short
> 
> |select coalesce((null, null), (10, 20)) as magic; |
> 
> returns
> 
> |magic ------- (,) (1 row)|
> 
> However, this is true:
> 
> |select (null, null) is null;|

I think this is actually a bug in the implementation, not in the 
documentation.  That is, the implementation should behave like the 
documentation suggests.