On Sun, 19 May 2024, Christophe Pettus wrote:
> 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 ...
Ah, yes. Hadn't thought of that. The statement would be
UPDATE people SET active=true WHERE email is not null;
Thanks, Christophe,
Rich