Re: UPDATE with multiple WHERE conditions

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: UPDATE with multiple WHERE conditions
Date: 2024-06-12 22:09:57
Message-ID: CAKFQuwbzJwRLWVdLBKN4wyvAEmw+RzkRMXaMPrUHx0aZbRAU=w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jun 12, 2024 at 2:28 PM Rich Shepard <rshepard(at)appl-ecosys(dot)com>
wrote:

> I have a table with 3492 rows. I want to update a boolean column from
> 'false' to 'true' for 295 rows based on the value of another column.
>
> Is there a way to access a file with those condition values?
>

I'll often just use a spreadsheet to build the 295 update commands and
copy-paste them into psql or whatnot.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2024-06-12 22:12:53 Re: Definging columns for INSERT statements
Previous Message David G. Johnston 2024-06-12 22:08:14 Re: PG16.1 security breach?