Postgres Pro
Downloads
Home   >   mailing lists

Thread: Addition to content

Addition to content

From
PG Doc comments form
Date:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/13/functions-conditional.html
Description:

Hello

I would be helpful to add that NULLIF and COALESCE need to be of same data
type. 

Thank you

Re: Addition to content

From
Tom Lane
Date:
PG Doc comments form <noreply@postgresql.org> writes:
> I would be helpful to add that NULLIF and COALESCE need to be of same data
> type. 

That's not actually a correct statement ... which I guess just reinforces
your point that the behavior needs to be documented.

            regards, tom lane

Re: Addition to content

From
Bruce Momjian
Date:
On Mon, Nov  9, 2020 at 11:09:59AM -0500, Tom Lane wrote:
> PG Doc comments form <noreply@postgresql.org> writes:
> > I would be helpful to add that NULLIF and COALESCE need to be of same data
> > type. 
> 
> That's not actually a correct statement ... which I guess just reinforces
> your point that the behavior needs to be documented.

FYI, this was done in this commit:

    commit 24b83a5082
    Author: Tom Lane <tgl@sss.pgh.pa.us>
    Date:   Mon Nov 9 12:02:24 2020 -0500
    
        Doc: clarify data type behavior of COALESCE and NULLIF.
    
        After studying the code, NULLIF is a lot more subtle than you might
        have guessed.
    
        Discussion: https://postgr.es/m/160486028730.25500.15740897403028593550@wrigleys.postgresql.org

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

  The usefulness of a cup is in its emptiness, Bruce Lee