Update with select

[tommy0123]

I've tried this update sql-statement with postgres it won't work. With oracle,... it's okay. How I can handle this with postgres?

update person SET (person_id, account, title, firstname, lastname, active) = (select person_pk as id1, uid, titel, vorname, familienname, true from fas.person p where person_pk=1540);

 

[stoolpigeon]

I've never done this personally. But I think that the information at:

http://www.faqs.org/docs/ppbook/x7050.htm

may point you in the right direction. It looks like you want to use FROM which is a non-standard extension of postgres.

The example they have is at the very bottom of the page I've given you above.

 

[ceco]

postgresql has different syntax for this kind of thing

check it here

http://www.postgresql.org/docs/8.1/interactive/sql-update.html

(see the FROM clause)