DEFAULT in <set clause list>

From: Neil Conway <neilc(at)samurai(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: Rod Taylor <rbt(at)rbt(dot)ca>
Subject: DEFAULT in <set clause list>
Date: 2003-03-24 17:17:29
Message-ID: 1048526249.421.7.camel@tokyo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Folks,

While browsing through the SQL spec (200x draft), I noticed the
following:

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

Any comments?

Cheers,

Neil

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-03-24 17:23:50 Re: Strange aggregate
Previous Message Teodor Sigaev 2003-03-24 17:04:35 Strange aggregate