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
