> <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...


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?


Reply via email to