Re: UPDATE with multiple WHERE conditions

Поиск
Список
Период
Сортировка
От Rich Shepard
Тема Re: UPDATE with multiple WHERE conditions
Дата
Msg-id 75689be4-1965-b361-ce50-cf3fb5edfbb@appl-ecosys.com
обсуждение исходный текст
Ответ на Re: UPDATE with multiple WHERE conditions  (Muhammad Salahuddin Manzoor <salahuddin.m@bitnine.net>)
Список pgsql-general
On Thu, 13 Jun 2024, Muhammad Salahuddin Manzoor wrote:

> You can use Temporary table. You could create a temporary table with one
> column containing the condition values and then use it to update your main
> table. This approach can be more flexible and cleaner than writing a
> script with multiple update statements.

Salahuddin,

Thank you. I thought this would be the best approach.

Regards,

Rich



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

Предыдущее
От: Muhammad Salahuddin Manzoor
Дата:
Сообщение: Re: UPDATE with multiple WHERE conditions
Следующее
От: Rich Shepard
Дата:
Сообщение: Re: Defining columns for INSERT statements