Re: [GENERAL] SQL - update table problem...

You can try using a combination of a view and rule attached to it for achieving the same...Thanks,---Shoaib MirEnterpriseDB (www.enterprisedb.com) On 11/13/06, Richard Huxton wrote: Marko Rihtar wrote:> Hi,>> i'm trying to make update on multiple tables but don't know how.> i

Re: [GENERAL] 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='12

Re: [GENERAL] SQL - update table problem...

Hi! According to the synopsis of UPDATE you just can update one table at a time. Just use more UPDATE commands inside a transaction. -- Matthias > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Marko Rihtar > Sent: Monday, November 13, 2006 2:21 PM