MIME-Version: 1.0
References: <c9cf4869-9d6d-7165-3f9f-611446bf961@appl-ecosys.com>
In-Reply-To: <c9cf4869-9d6d-7165-3f9f-611446bf961@appl-ecosys.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Wed, 12 Jun 2024 17:48:26 -0400
Message-ID: <CANzqJaB48SjPZrOqEn-wawob+GfKQrwLouyNP_zoPW_5QsvFFw@mail.gmail.com>
Subject: Re: UPDATE with multiple WHERE conditions
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000498688061ab858d0"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaB48SjPZrOqEn-wawob%2BGfKQrwLouyNP_zoPW_5QsvFFw%40mail.gmail.com>
Precedence: bulk

--000000000000498688061ab858d0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Jun 12, 2024 at 5:28=E2=80=AFPM Rich Shepard <rshepard@appl-ecosys.=
com>
wrote:

> I have a table with 3492 rows. I want to update a boolean column from
> 'false' to 'true' for 295 rows based on the value of another column.
>
> Is there a way to access a file with those condition values? If not, shou=
ld
> I create a temporary table with one column containing those values, or do=
 I
> write a psql script with 295 lines, one for each row to be updated?
>

A plain UPDATE might work.

UPDATE to_be_updated a
SET bool_col =3D true
FROM other_table b
WHERE a.pk =3D b.pk
  AND b.field3 =3D mumble;

(You can join them, right?)

--000000000000498688061ab858d0
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Jun 12, 2024 at 5:28=E2=80=AFPM R=
ich Shepard &lt;<a href=3D"mailto:rshepard@appl-ecosys.com">rshepard@appl-e=
cosys.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid=
 rgb(204,204,204);padding-left:1ex">I have a table with 3492 rows. I want t=
o update a boolean column from<br>
&#39;false&#39; to &#39;true&#39; for 295 rows based on the value of anothe=
r column.<br>
<br>
Is there a way to access a file with those condition values? If not, should=
<br>
I create a temporary table with one column containing those values, or do I=
<br>
write a psql script with 295 lines, one for each row to be updated?<br></bl=
ockquote><div><br></div><div>A plain=C2=A0UPDATE might work.=C2=A0=C2=A0</d=
iv><div>=C2=A0</div><div><font face=3D"monospace">UPDATE to_be_updated a</f=
ont></div><div><font face=3D"monospace">SET bool_col =3D true</font></div><=
div><font face=3D"monospace">FROM other_table b</font></div><div><font face=
=3D"monospace">WHERE <a href=3D"http://a.pk">a.pk</a> =3D <a href=3D"http:/=
/b.pk">b.pk</a></font></div><div><font face=3D"monospace">=C2=A0 AND b.fiel=
d3 =3D mumble;</font></div><div><br></div><div>(You can join them, right?)<=
/div></div></div>

--000000000000498688061ab858d0--