Re: DEFAULT in - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: DEFAULT in
Date
Msg-id 03fb01c2f26b$f38b99b0$6500a8c0@fhp.internal
Whole thread Raw
In response to DEFAULT in  (Neil Conway <neilc@samurai.com>)
Responses Re: DEFAULT in
List pgsql-hackers
> <set clause list> (the list of SET expressions in an UPDATE statement;
> section 14.12) allows a <contextually typed value specification> on the
> right-hand side of SET assignments. One of the possibilities for a
> <contextually typed value specification> is DEFAULT (section 6.5).
>
> In other words, this syntax should be legal:
>
> UPDATE sometable SET somecolumn = DEFAULT;
>
> but it doesn't appear to be implemented as of CVS tip.

Hmmm...I ran into a situation where I wanted that just the other day.
INSERT INTO...SELECT FROM kind of thing...

Chris



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: updateable cursors & visibility
Next
From: Bruce Momjian
Date:
Subject: Re: PQescapeBytea on Win32