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

From Tom Lane
Subject Re: Default values in functions
Date
Msg-id 2184626.1640824087@sss.pgh.pa.us
Whole thread Raw
In response to Re: Default values in functions  (Michael Lewis <mlewis@entrata.com>)
List pgsql-general
Michael Lewis <mlewis@entrata.com> writes:
> Understood. My hope is to pass a parameter that gets overridden by the
> default so that I can pass other parameters that come after.

As David explained, function parameters don't work that way.
You could mechanize something like substitute-a-default-for-
null-input, but you'll have to do it with explicit logic.

            regards, tom lane



pgsql-general by date:

Previous
From: Michael Lewis
Date:
Subject: Re: Default values in functions
Next
From: Tom Lane
Date:
Subject: Re: Default values in functions