On Sun, 19 May 2024, Ray O'Donnell wrote:
> Could you create a table with just person_id values whose rows are to be
> updated? Then you could do something like this:
>
> update people set active = true where exists (
> select 1 from temporary_table where person_id = people.person_id
> );
>
> That's just off the top of my head and might not be correct, but that's the
> way I'd be thinking.
Ray,
I thought of doing this but it's a one-off activity. I would create and
insert the table, then delete it when done. Will keep this in mind.
Thanks,
Rich