Re: Default values in functions

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Default values in functions
Date: 2021-12-30 00:17:18
Message-ID: CAHOFxGpWRrBeEZJQP4-Z0Yahs3mFo3z=hQn-eJgStZPhnNVZug@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Dec 29, 2021, 4:34 PM David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Lewis 2021-12-30 00:22:49 Re: Default values in functions
Previous Message David G. Johnston 2021-12-29 23:34:37 Re: Default values in functions