Re: Updating 457 rows in a table

[Christophe Pettus]

> On May 19, 2024, at 11:30, Rich Shepard <rshep...@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 ...