subqueries as values in updates

From: patrick(dot)jacquot(at)anpe(dot)fr
To: liste SQL <pgsql-sql(at)postgresql(dot)org>
Subject: subqueries as values in updates
Date: 2000-12-08 13:00:25
Message-ID: 3A30DB68.6B97A867@anpe.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

hello, list.
are subqueries alloved as values in an update command ?
e.g.

update a set a.attribute1 = a.attribute1 +
(select sum(b.attribute1) from b where b.attribute2=a.attribute2);

If yes, how is the correct syntax ?
If not, is there a hope for it in a future version ?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2000-12-08 17:23:08 Re: FOREIGN KEY errors.
Previous Message Francis Solomon 2000-12-08 11:30:12 RE: subqueries as values in updates