Re: [HACKERS] DEFAULT in set clause list

2003-03-28 Thread Rod Taylor 
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 [EMAIL PROTECTED]

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


signature.asc
Description: This is a digitally signed message part

Re: [HACKERS] DEFAULT in set clause list

2003-03-24 Thread Christopher Kings-Lynne 
 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