Re: Slick way to update multiple tables.

Поиск
Список
Период
Сортировка
От Ron
Тема Re: Slick way to update multiple tables.
Дата
Msg-id cfa99b67-50e1-47f7-a687-f1945c82f0a9@gmail.com
обсуждение исходный текст
Ответ на Slick way to update multiple tables.  ("Theodore M Rolle, Jr." <stercor@gmail.com>)
Список pgsql-general
On 4/1/21 11:16 AM, Theodore M Rolle, Jr. wrote:
I SELECT items from three tables.

It seems that the only way to put updated fields into their proper table is to query each field, then UPDATE each table.

Am I missing something here?
Is there a way to do this automatically?


Did you join the three tables when querying?

--
Angular momentum makes the world go 'round.

В списке pgsql-general по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: Is replacing transactions with CTE a good idea?
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Is replacing transactions with CTE a good idea?