Re: UPDATE with multiple WHERE conditions

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: UPDATE with multiple WHERE conditions
Date: 2024-06-12 21:34:09
Message-ID: 75689be4-1965-b361-ce50-cf3fb5edfbb@appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2024-06-12 21:36:51 Re: Defining columns for INSERT statements
Previous Message Muhammad Salahuddin Manzoor 2024-06-12 21:31:43 Re: UPDATE with multiple WHERE conditions