Re: Updating 457 rows in a table - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Updating 457 rows in a table
Date
Msg-id 1E14886A-BBCB-40E4-8231-1159D12BD261@thebuild.com
Whole thread Raw
In response to Updating 457 rows in a table  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Updating 457 rows in a table
List pgsql-general

> On May 19, 2024, at 09:54, Rich Shepard <rshepard@appl-ecosys.com> wrote:
>
> Specifically, in the 'people' table I want to change the column 'active'
> from false to true for 457 specific person_id row numbers.

UPDATE people SET active=true WHERE id IN (...);

The ... can either be an explicit list of the ids, or a SELECT id WHERE if you have a predicate that selects the
appropriateids. 


pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Updating 457 rows in a table
Next
From: Ray O'Donnell
Date:
Subject: Re: Updating 457 rows in a table