public inbox for [email protected]  

help / color / mirror / Atom feed

From: Rich Shepard <[email protected]>
To: [email protected]
Subject: Re: Updating 457 rows in a table
Date: Sun, 19 May 2024 11:32:27 -0700 (PDT)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Updating 457 rows in a table
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox