Re: UPDATE with multiple WHERE conditions
Rich Shepard <rshepard@appl-ecosys.com>
From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@lists.postgresql.org
Date: 2024-06-12T21:34:09Z
Lists: 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