From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Rod Taylor <rbt(at)rbt(dot)ca> |
Cc: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Neil Conway <neilc(at)samurai(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: DEFAULT in <set clause list> |
Date: | 2003-05-26 02:56:32 |
Message-ID: | 200305260256.h4Q2uWq07499@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Added to TODO:
* Allow UPDATE to use SET col = DEFAULT
---------------------------------------------------------------------------
Rod Taylor wrote:
-- Start of PGP signed section.
> 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
-- End of PGP section, PGP failed!
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 2003-05-26 04:07:33 | Re: CVS Servers (Anonymous) |
Previous Message | Bruce Momjian | 2003-05-26 02:35:57 | Re: Domain breakage |