Re: DEFAULT in <set clause list>

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Neil Conway" <neilc(at)samurai(dot)com>, "PostgreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org>
Cc: "Rod Taylor" <rbt(at)rbt(dot)ca>
Subject: Re: DEFAULT in <set clause list>
Date: 2003-03-25 01:14:57
Message-ID: 03fb01c2f26b$f38b99b0$6500a8c0@fhp.internal
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-03-25 02:46:18 Re: PQescapeBytea on Win32
Previous Message Nick Piggin 2003-03-24 22:30:50 Re: IO scheduler vs PostgreSQL performance measurement