Date: Sun, 19 May 2024 11:32:27 -0700 (PDT)
From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: Updating 457 rows in a table
In-Reply-To: <4001d2f9-1a70-47e5-9f21-754a5d7497bf@rodonnell.ie>
Message-ID: <9753bd1a-6b25-b2ce-c2cc-aca258febb8@appl-ecosys.com>
References: <164b3681-7a42-1e5-6a7b-80196ed33ded@appl-ecosys.com> <4001d2f9-1a70-47e5-9f21-754a5d7497bf@rodonnell.ie>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8BIT
Archived-At: <https://www.postgresql.org/message-id/9753bd1a-6b25-b2ce-c2cc-aca258febb8%40appl-ecosys.com>
Precedence: bulk

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