Feedback-ID: ia2694551:Fastmail
Date: Thu, 13 Jun 2024 12:34:25 +0200
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Rich Shepard <rshepard@appl-ecosys.com>, 
	pgsql-general@lists.postgresql.org
Subject: Re: UPDATE with multiple WHERE conditions
Message-ID: <202406131034.pfckaz3va2bb@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <CAKFQuwbzJwRLWVdLBKN4wyvAEmw+RzkRMXaMPrUHx0aZbRAU=w@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/202406131034.pfckaz3va2bb%40alvherre.pgsql>
Precedence: bulk

On 2024-Jun-12, David G. Johnston wrote:

> On Wed, Jun 12, 2024 at 2:28 PM Rich Shepard <rshepard@appl-ecosys.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.
> 
> I'll often just use a spreadsheet to build the 295 update commands and
> copy-paste them into psql or whatnot.

A closely related technique: if you have a query that generates the
UPDATE commands you need, you can run it under \gexec in psql, and
they'll be executed.

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
Al principio era UNIX, y UNIX habló y dijo: "Hello world\n".
No dijo "Hello New Jersey\n", ni "Hello USA\n".