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