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

> On May 19, 2024, at 11:30, Rich Shepard <rshepard@appl-ecosys.com> wrote:
> That's a good idea; I can use a predicate to identify the rows to update.
> That would be shorter than a long, comma-separated list.

Of course, you can probably also shorten the query to:

    UPDATE people SET active=true WHERE ...

Where ... is the predicate you would have used in the SELECT id WHERE ...