On Sun, 19 May 2024, Christophe Pettus wrote:
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 appropriate ids.
Christophe, 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. Thanks, Rich
