Postgres Pro
Downloads
Home   >   mailing lists

Re: Select default values - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Select default values
Date
Msg-id 48885CAE.7080005@archonet.com
Whole thread Raw
In response to Re: Select default values  (Giorgio Valoti <giorgio_v@mac.com>)
Responses Re: Select default values  (Giorgio Valoti <giorgio_v@mac.com>)
List pgsql-sql
Tree view 
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.

--   Richard Huxton  Archonet Ltd

pgsql-sql by date:

Previous
From: Giorgio Valoti
Date:
Subject: Re: Select default values
Next
From: "Anoop G"
Date:
Subject: postgres time zone settings