Re: It is possible to update more than 1 table in the same update statement?
| От | Andre Lopes |
|---|---|
| Тема | Re: It is possible to update more than 1 table in the same update statement? |
| Дата | |
| Msg-id | AANLkTi=1mCZix50cyKn-jGFbB1hW5YdgmfNBNMJJdd-W@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: It is possible to update more than 1 table in the same update statement? (Scott Ribe <scott_ribe@killerbytes.com>) |
| Ответы |
Re: It is possible to update more than 1 table in the same update statement?
Re: It is possible to update more than 1 table in the same update statement? |
| Список | pgsql-general |
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,
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,
On Sun, Nov 7, 2010 at 3:11 PM, Scott Ribe <scott_ribe@killerbytes.com> wrote:
On Nov 7, 2010, at 7:58 AM, Andre Lopes wrote:Transactions???
> need to update various tables in the same update. It is possible to do it?
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
В списке pgsql-general по дате отправления: