Re: UPDATE with multiple WHERE conditions - Mailing list pgsql-general

From Rich Shepard
Subject Re: UPDATE with multiple WHERE conditions
Date
Msg-id 75689be4-1965-b361-ce50-cf3fb5edfbb@appl-ecosys.com
Whole thread Raw
In response to Re: UPDATE with multiple WHERE conditions  (Muhammad Salahuddin Manzoor <salahuddin.m@bitnine.net>)
List 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 by date:

Previous
From: Muhammad Salahuddin Manzoor
Date:
Subject: Re: UPDATE with multiple WHERE conditions
Next
From: Rich Shepard
Date:
Subject: Re: Defining columns for INSERT statements