Thread: SQL - update table problem...

Hi,

first i'm sorry if this message appears twice. first time didn't get through 
because i wasn't registered.

i'm trying to do 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 know that this syntax is not supported with postgres but i tried to 
rewrite the code using this synopsis:

UPDATE [ ONLY ] table SET column = { expression | DEFAULT } [, ...]  [ FROM fromlist ]  [ WHERE condition ]

i failed again.

thanks for help

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

On Mon, Nov 13, 2006 at 11:36:05 +0100, Marko Rihtar <riki_fox@hotmail.com> wrote:
> 
> i'm trying to do update on multiple tables but don't know how.
> is something like this posible with postgresql?

I believe you need to use multiple update statements to do this. Each
update can only update one table. You can join with other tables to
select which rows to update, but that doesn't let you update more than
one table at once.