Re: SQL - update table problem...

You can try using a combination of a view and rule attached to it for
achieving the same...

Thanks,
-------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 11/13/06, Richard Huxton <dev(at)archonet(dot)com> wrote:
>
> 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
>