Re: DEFAULT in <set clause list>

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(at)rbt(dot)ca>

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