Postgres Pro
Downloads
Home   >   mailing lists

Re: It is possible to update more than 1 table in the same update statement? - Mailing list pgsql-general

From Szymon Guz
Subject Re: It is possible to update more than 1 table in the same update statement?
Date
Msg-id AANLkTimbyGyKLYa__J=0R4GuSU24YfpV1r3wRxV4vam+@mail.gmail.com
Whole thread Raw
In response to Re: It is possible to update more than 1 table in the same update statement?  (Andre Lopes <lopes80andre@gmail.com>)
Responses Re: It is possible to update more than 1 table in the same update statement?  (Andre Lopes <lopes80andre@gmail.com>)
List pgsql-general
Tree view


On 7 November 2010 16:20, Andre Lopes <lopes80andre@gmail.com> wrote:
Sorry for not explain well.

I mean update more than one table at the same time with something like this:

update table1, table2
set
table1.f1 = 'aaa',
table2.date = '2001-01-01'
where
table1.id = 'x1' and table2.id = 'x1'

Something like this is possible? It is the best way to do it?

Best Regards,


This is not possible, however you could do two updates in one transaction.

regards
Szymon

pgsql-general by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: Looking for a Generic lightweight job queueing (stack) implementation.
Next
From: Magnus Hagander
Date:
Subject: Re: Run "postgresql\9.0\data" on a RAID-1 disk on my Local Area Network (LAN)