Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group