Skip site navigation (1) Skip section navigation (2)

Re: Select default values

From: "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com>
To: "Giorgio Valoti" <giorgio_v(at)mac(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Select default values
Date: 2008-07-24 21:15:36
Message-ID: 396486430807241415k5df3df3fgd0550016c819fe48@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
On Thu, Jul 24, 2008 at 12:35 PM, Giorgio Valoti <giorgio_v(at)mac(dot)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

In response to

Responses

pgsql-sql by date

Next:From: Chris HoyDate: 2008-07-25 08:32:23
Subject: Arrays, types and prodedures
Previous:From: Giorgio ValotiDate: 2008-07-24 19:35:51
Subject: Re: Select default values

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group