Re: Default values in functions - Mailing list pgsql-general

From Michael Lewis
Subject Re: Default values in functions
Date
Msg-id CAHOFxGpWRrBeEZJQP4-Z0Yahs3mFo3z=hQn-eJgStZPhnNVZug@mail.gmail.com
Whole thread Raw
In response to Re: Default values in functions  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Default values in functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

On Wed, Dec 29, 2021, 4:34 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
That isn’t how it works.  Absence is what is important.  Null is not absence.  As you showed, if you want nulls to be converted to defaults you can use coalesce.

Thanks sir. It seems unfortunate that there is not a way to indicate absence of the third parameter if I need to set a value for the fourth parameter.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Default values in functions
Next
From: Michael Lewis
Date:
Subject: Re: Default values in functions