Re: Updating 457 rows in a table - Mailing list pgsql-general

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