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, table2set table1.f1 = 'aaa',table2.date = '2001-01-01' wheretable1.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.regardsSzymon
Sorry for not explain well.I mean update more than one table at the same time with something like this:update table1, table2set table1.f1 = 'aaa',table2.date = '2001-01-01' wheretable1.id = 'x1' and table2.id = 'x1'Something like this is possible? It is the best way to do it?Best Regards,
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных