> <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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html