Re: Select default values

From: Richard Huxton <dev(at)archonet(dot)com>
To: Giorgio Valoti <giorgio_v(at)mac(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Select default values
Date: 2008-07-24 10:42:54
Message-ID: 48885CAE.7080005@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Anoop G 2008-07-24 12:56:50 postgres time zone settings
Previous Message Giorgio Valoti 2008-07-24 10:30:25 Re: Select default values