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
