Re: UPDATE

* Denkewitz Lars <lars(dot)denkewitz(at)dogro(dot)de> schrieb:
> Hallo,
>
> sorry, ich habe mich da völlg falsch ausgedrückt:
>
> update testdb set (feld1, feld2, feld3) = select (feld4,feld5,feld6) from
> test2db where id = 100;

UPDATE testdb
SET feld1 = testdb2.feld4,
feld2 = testdb2.feld5,
feld4 = testdb2.feld6
WHERE
testdb.id = 100 AND testdb2.id = 100;

cu

--
---------------------------------------------------------------------
Enrico Weigelt == metux IT service
phone: +49 36207 519931 www: http://www.metux.de/
fax: +49 36207 519932 email: contact(at)metux(dot)de
---------------------------------------------------------------------
Realtime Forex/Stock Exchange trading powered by postgresSQL :))
http://www.fxignal.net/
---------------------------------------------------------------------