Andreas wrote:
Doesn't something like
UPDATE t1 SET col1=cola, col2=colb FROM t1 JOIN anothertable ot ON t1.id=ot.id WHERE ...
Work the way you'd like it? I'd expect this syntax to be as widely portable and performant.
Hmm, 'from' in an update is a PostgreSQL extension to the update command :).
Ooops... Oracle doesn't know it, I used to use it on MSSQL.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html