MIME-Version: 1.0
In-Reply-To: 
 <CABoe=cS68ZKuY09AUE92QuZbZG=UQozBL0m+nWQQ-oLFfDhfFA@mail.gmail.com>
References: 
 <CABoe=cS68ZKuY09AUE92QuZbZG=UQozBL0m+nWQQ-oLFfDhfFA@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Fri, 22 Mar 2024 06:35:22 -0700
Message-ID: 
 <CAKFQuwbrQUPOPhPQbor2=Fhi73bZPm-PYa4aV9oCERZD8SqwLA@mail.gmail.com>
Subject: Re: UPDATE with AND clarification
To: Jamie Thompson <jthompson.neuk@gmail.com>
Cc: "pgsql-sql@lists.postgresql.org" <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000055ad8a06143fe50a"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwbrQUPOPhPQbor2%3DFhi73bZPm-PYa4aV9oCERZD8SqwLA%40mail.gmail.com>
Precedence: bulk

--00000000000055ad8a06143fe50a
Content-Type: text/plain; charset="UTF-8"

On Friday, March 22, 2024, Jamie Thompson <jthompson.neuk@gmail.com> wrote:

>
> Earlier today, I was running some sql for someone which they had submitted
> as:
> > UPDATE tablename SET col1 = val1 AND col2 = val2 WHERE id = X
>

I presume these columns are booleans.  So you wrote something like:
Set col1 = ( true and false = true )

Which in this case must coincidentally have produced whatever boolean value
already existed in col1.

David J.

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

On Friday, March 22, 2024, Jamie Thompson &lt;<a href=3D"mailto:jthompson.n=
euk@gmail.com">jthompson.neuk@gmail.com</a>&gt; wrote:<br><blockquote class=
=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex"><div dir=3D"ltr"><div><div><div><div><div><div><div><div><div=
><br></div></div></div></div>Earlier today, I was running some sql for some=
one which they had submitted as:<br>&gt; UPDATE=C2=A0tablename SET col1 =3D=
 val1 AND col2 =3D val2 WHERE id =3D X</div></div></div></div></div></div><=
/blockquote><div><br></div><div>I presume these columns are booleans.=C2=A0=
 So you wrote something like:</div><div>Set col1 =3D ( true and false =3D t=
rue )</div><div><br></div><div>Which in this case must coincidentally have =
produced whatever boolean value already existed in col1.</div><div><br></di=
v><div>David J.</div><div><br></div>

--00000000000055ad8a06143fe50a--