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

From Alvaro Herrera
Subject Re: UPDATE with multiple WHERE conditions
Date
Msg-id 202406131034.pfckaz3va2bb@alvherre.pgsql
Whole thread Raw
In response to Re: UPDATE with multiple WHERE conditions  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
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".



pgsql-general by date:

Previous
From: Koen De Groote
Date:
Subject: Re: Questions on logical replication
Next
From: Daniel Gustafsson
Date:
Subject: Re: Question about UNIX socket connections and SSL