From: | Ian Barwick <barwick(at)gmx(dot)net> |
---|---|
To: | "Vangelis-Maria Tougia" <tougias(at)cytanet(dot)com(dot)cy>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: UPDATE table SET col = (SELECT ...) |
Date: | 2003-06-26 21:11:10 |
Message-ID: | 200306262311.10435.barwick@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Wednesday 25 June 2003 11:00, Vangelis-Maria Tougia wrote:
> Hi,
> I found follwing email sent to you in internet.
> I am interested in same issue myself.
> Did you finally found out any more information about how to Update a column
> of a table by selecting value from another table?
Not sure if this has been answered previously, but here goes:
> Hello,
>
> If I understand the SQL references I have read, UPDATEs are allowed to
> pull data from SELECT statements, something like
>
> UPDATE table SET col1 = (SELECT val1 FROM table WHERE id = 34),
> SET col2 = (SELECT val2 FROM table WHERE id = 34)
^^^
> WHERE id = 35;
The second "SET" is not necessary or allowed and is causing the update to
fail.
Ian Barwick
barwick(at)gmx(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-06-27 03:49:22 | Re: Rules: passing new/old to functions |
Previous Message | Rod Taylor | 2003-06-26 17:23:39 | Re: Temporary table performance? |