Re: SQL - update table problem...

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