Re: Select default values - Mailing list pgsql-sql

From Richard Broersma
Subject Re: Select default values
Date
Msg-id 396486430807241415k5df3df3fgd0550016c819fe48@mail.gmail.com
Whole thread Raw
In response to Re: Select default values  (Giorgio Valoti <giorgio_v@mac.com>)
Responses Re: Select default values
List pgsql-sql
On Thu, Jul 24, 2008 at 12:35 PM, Giorgio Valoti <giorgio_v@mac.com> wrote:

>> Um - there is no default value for a function.
>
> Without this "feature" you have to overload
> the function arguments.

You could pass a casted null to the function.  The would eliminate
function overloading.  Then internally you could handle the null by
passing DEFAULTS to you INSERT or UPDATE statements.  I don't know if
this would work for you in this case.

-- 
Regards,
Richard Broersma Jr.

Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug


pgsql-sql by date:

Previous
From: Giorgio Valoti
Date:
Subject: Re: Select default values
Next
From: "Chris Hoy"
Date:
Subject: Arrays, types and prodedures