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: Muhammad Salahuddin Manzoor <salahuddin.m@bitnine.net>
Date: Thu, 13 Jun 2024 02:31:43 +0500
Message-ID: <CAKD7CD=p9KZfB9u+A=p2-Eju1hkUGBnwJMg+xEk82K6wm3mcTA@mail.gmail.com>
Subject: Re: UPDATE with multiple WHERE conditions
To: Rich Shepard <rshepard@appl-ecosys.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000acd3d6061ab81cc8"
Archived-At: <https://www.postgresql.org/message-id/CAKD7CD%3Dp9KZfB9u%2BA%3Dp2-Eju1hkUGBnwJMg%2BxEk82K6wm3mcTA%40mail.gmail.com>
Precedence: bulk

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

Greetings,

You can use Temporary table. You could create a temporary table with one
column containing the condition values and then use it to update your main
table. This approach can be more flexible and cleaner than writing a script
with multiple update statements.

-- Create a temporary table with one column containing the condition values
CREATE TEMPORARY TABLE temp_conditions (condition_value TEXT);

-- Insert the condition values into the temporary table
INSERT INTO temp_conditions (condition_value) VALUES
    ('value1'),
    ('value2'),
    ('value3'),
    -- Add more values as needed...
    ('value295');

-- Update the boolean column based on the condition values
UPDATE your_table
SET boolean_column =3D true
WHERE condition_column IN (SELECT condition_value FROM temp_conditions);

-- Clean up: drop the temporary table
DROP TABLE IF EXISTS temp_conditions;

*Salahuddin (=EC=82=B4=EB=9D=BC=ED=9B=84=EB=94=98**)*


On Thu, 13 Jun 2024 at 02:28, 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?
>
> TIA,
>
> Rich
>
>
>

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

<div dir=3D"ltr">Greetings,<div><br></div><div>You can use Temporary table.=
 You could create a temporary table with one column containing the conditio=
n values and then use it to update your main table. This approach can be mo=
re flexible and cleaner than writing a script with multiple update statemen=
ts.<br><br>-- Create a temporary table with one column containing the condi=
tion values<br>CREATE TEMPORARY TABLE temp_conditions (condition_value TEXT=
);<br><br>-- Insert the condition values into the temporary table<br>INSERT=
 INTO temp_conditions (condition_value) VALUES<br>=C2=A0 =C2=A0 (&#39;value=
1&#39;),<br>=C2=A0 =C2=A0 (&#39;value2&#39;),<br>=C2=A0 =C2=A0 (&#39;value3=
&#39;),<br>=C2=A0 =C2=A0 -- Add more values as needed...<br>=C2=A0 =C2=A0 (=
&#39;value295&#39;);<br><br>-- Update the boolean column based on the condi=
tion values<br>UPDATE your_table<br>SET boolean_column =3D true<br>WHERE co=
ndition_column IN (SELECT condition_value FROM temp_conditions);<br><br>-- =
Clean up: drop the temporary table<br>DROP TABLE IF EXISTS temp_conditions;=
<br><div><div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail=
_signature"><div dir=3D"ltr"><table width=3D"520px" height=3D"100px" cellsp=
acing=3D"0" cellpadding=3D"0" style=3D"font-size:13px;border:1px solid rgb(=
255,255,255);color:rgb(51,51,51)"><tbody><tr><td style=3D"border:1px solid =
rgb(255,255,255)"><br></td><td style=3D"border:1px solid rgb(255,255,255)">=
<p dir=3D"ltr" style=3D"line-height:1.2;margin-top:6pt;margin-bottom:6pt"><=
font color=3D"#2255ff" face=3D"arial, sans-serif" size=3D"2"><b>Salahuddin =
(=EC=82=B4=EB=9D=BC=ED=9B=84=EB=94=98</b></font><b style=3D"color:rgb(34,85=
,255);font-family:arial,sans-serif;font-size:small">)</b></p></td></tr></tb=
ody></table></div></div></div><br></div></div><br><div class=3D"gmail_quote=
"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, 13 Jun 2024 at 02:28, Rich =
Shepard &lt;<a href=3D"mailto:rshepard@appl-ecosys.com">rshepard@appl-ecosy=
s.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"ma=
rgin: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 to 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>
<br>
TIA,<br>
<br>
Rich<br>
<br>
<br>
</blockquote></div>

--000000000000acd3d6061ab81cc8--