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


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

Reply via email to