Re: Select default values - Mailing list pgsql-sql

From Giorgio Valoti
Subject Re: Select default values
Date
Msg-id 1E799827-0C8E-4238-8D9F-F7DBA2B99DFF@mac.com
Whole thread Raw
In response to Re: Select default values  (Richard Huxton <dev@archonet.com>)
Responses Re: Select default values
List 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



pgsql-sql by date:

Previous
From: "Jaime Casanova"
Date:
Subject: Re: postgres time zone settings
Next
From: "Richard Broersma"
Date:
Subject: Re: Select default values