Marko Rihtar wrote: > Hi, > > i'm trying to make update on multiple tables but don't know how. > is something like this posible with postgresql? > > update table1 > join table2 on ( table1.id=table2.t1) > join table3 on (table2.id=table3.t2) > set table1.name='test', table2.sum=table1.x+table2.y, > table3.cell='123456789' > where table1.id=6
I don't know of an SQL variant to handle this case. Usually people are trying to update a single table based on joining to several others.
In your case you'll have to issue three update statements wrapped in a transaction.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings