Re: Select default values

From: Giorgio Valoti <giorgio_v(at)mac(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Select default values
Date: 2008-07-24 19:35:51
Message-ID: 1E799827-0C8E-4238-8D9F-F7DBA2B99DFF@mac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On 24/lug/08, at 12:42, Richard Huxton wrote:

> Giorgio Valoti wrote:
>>> postgres=# insert into f(a,b) values(default, default) returning *;
>> It seems that you can’t use the same syntax with function calls:
>> select function(default,default);
>> gives a syntax error. Is it expected?
>
> Um - there is no default value for a function.

Yes, but you could define a domain with a default value and using it
as an IN argument for a function. In that case it would handy to be
able to use the default value, wouldn’t it? Without this "feature" you
have to overload the function arguments.

--
Giorgio Valoti

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Broersma 2008-07-24 21:15:36 Re: Select default values
Previous Message Jaime Casanova 2008-07-24 16:47:06 Re: postgres time zone settings