Re: DEFAULT in - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: DEFAULT in
Date
Msg-id 1048857827.2014.20.camel@jester
Whole thread Raw
In response to Re: DEFAULT in  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Responses Re: DEFAULT in  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
I'll look into it...

On Mon, 2003-03-24 at 20:14, Christopher Kings-Lynne wrote:
> > <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
--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

pgsql-hackers by date:

Previous
From: Lee Kindness
Date:
Subject: ECPG thread-safety
Next
From: mlw
Date:
Subject: PostgreSQL and SOAP, version 7.4/8.0