MIME-Version: 1.0
References: <164b3681-7a42-1e5-6a7b-80196ed33ded@appl-ecosys.com>
In-Reply-To: <164b3681-7a42-1e5-6a7b-80196ed33ded@appl-ecosys.com>
From: Muhammad Ikram <mmikram@gmail.com>
Date: Sun, 19 May 2024 22:06:04 +0500
Message-ID: <CAGeimVoWSRvrE4M1ppxVAkAvoFr=XXKT8NQu1dftKFnx7V45MA@mail.gmail.com>
Subject: Re: Updating 457 rows in a table
To: Rich Shepard <rshepard@appl-ecosys.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000b20abf0618d19a5b"
Archived-At: <https://www.postgresql.org/message-id/CAGeimVoWSRvrE4M1ppxVAkAvoFr%3DXXKT8NQu1dftKFnx7V45MA%40mail.gmail.com>
Precedence: bulk

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

Hi Rich,

Based on what I could understand is, here is an example

UPDATE employees
SET  salary =3D salary + 500
WHERE department_id =3D 'Sales';

Sorry, if I misunderstood your question.

Regards,
Muhammad Ikram
Bitnine

On Sun, May 19, 2024 at 9:54=E2=80=AFPM Rich Shepard <rshepard@appl-ecosys.=
com>
wrote:

> Searching the postgresql doc for UPDATE the examples I find show updating
> one or a few rows in a table. I have 457 rows to update in a table.
>
> I could write a .sql script with 457 lines, each updating one row of the
> table. My web search for `sql: update table rows from a file of column
> values' finds pages for single row updates and updating a table from
> another
> table, but neither is what I want.
>
> I want to change a column value in a table based on the value of a
> different
> column in that same table.
>
> Specifically, in the 'people' table I want to change the column 'active'
> from false to true for 457 specific person_id row numbers.
>
> Is there a way to do this without manually writing 457 'update ...' rows =
in
> a .sql file?
>
> TIA,
>
> Rich
>
>
>
>

--=20
Muhammad Ikram

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

<div dir=3D"ltr"><div>Hi Rich,</div><div><br></div><div>Based on what I cou=
ld understand is, here is an example</div><div><br></div><div>UPDATE employ=
ees</div><div>SET=C2=A0 salary =3D salary + 500</div><div>WHERE department_=
id =3D &#39;Sales&#39;;</div><div><br></div><div>Sorry, if I misunderstood =
your question.</div><div><br></div><div>Regards,</div><div>Muhammad Ikram</=
div><div>Bitnine </div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr=
" class=3D"gmail_attr">On Sun, May 19, 2024 at 9:54=E2=80=AFPM Rich Shepard=
 &lt;<a href=3D"mailto:rshepard@appl-ecosys.com">rshepard@appl-ecosys.com</=
a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0p=
x 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Se=
arching the postgresql doc for UPDATE the examples I find show updating<br>
one or a few rows in a table. I have 457 rows to update in a table.<br>
<br>
I could write a .sql script with 457 lines, each updating one row of the<br=
>
table. My web search for `sql: update table rows from a file of column<br>
values&#39; finds pages for single row updates and updating a table from an=
other<br>
table, but neither is what I want.<br>
<br>
I want to change a column value in a table based on the value of a differen=
t<br>
column in that same table.<br>
<br>
Specifically, in the &#39;people&#39; table I want to change the column =
9;active&#39;<br>
from false to true for 457 specific person_id row numbers.<br>
<br>
Is there a way to do this without manually writing 457 &#39;update ...&#39;=
 rows in<br>
a .sql file?<br>
<br>
TIA,<br>
<br>
Rich<br>
<br>
<br>
<br>
</blockquote></div><br clear=3D"all"><br><span class=3D"gmail_signature_pre=
fix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"l=
tr"><div>Muhammad Ikram<br><br></div></div></div>

--000000000000b20abf0618d19a5b--