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...

3, 2006 2:21 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL] SQL - update table problem... > > > Hi, > > i'm trying to make update on multiple tables but don't know how. > is something like this posible with postgresql? > > update table1 >

[GENERAL] SQL - update table problem...

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 table