View Single Post

   
  #15 (permalink)  
Old 07-28-2008, 06:43 PM
Richard Broersma
 
Posts: n/a
Default Re: Select default values

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

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply With Quote