Re: Updating 457 rows in a table

[Rich Shepard]

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