MIME-Version: 1.0
References: <BYAPR12MB280818626E29A0CBC38DAEAABA232@BYAPR12MB2808.namprd12.prod.outlook.com>
In-Reply-To: <BYAPR12MB280818626E29A0CBC38DAEAABA232@BYAPR12MB2808.namprd12.prod.outlook.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Fri, 22 Nov 2024 13:12:46 -0700
Message-ID: <CAKFQuwahNdTb3kHWyDGnxkTqD3oH18tS597y3WKv8UdNz5-xhw@mail.gmail.com>
Subject: Re: Wired behaviour from SELECT
To: Arbol One <arbolone@hotmail.ca>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>, 
	PostGreSQL MailingList <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000bd4d010627860382"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwahNdTb3kHWyDGnxkTqD3oH18tS597y3WKv8UdNz5-xhw%40mail.gmail.com>
Precedence: bulk

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

On Fri, Nov 22, 2024 at 1:07=E2=80=AFPM Arbol One <arbolone@hotmail.ca> wro=
te:

> The below sql statement produces the right output
> SELECT nickname, password FROM password WHERE id=3D'0938105618107N1';
>   nickname   | password
> -------------+----------
>  Piccard@@21 |  Arbol
> (1 row)
> However, if this sql statement produces the wrong output
>
>
>
> *SELECT nickname, password FROM password WHERE nickname=3D'Arbol';  nickn=
ame
> | password ----------+---------- (0 rows)*
> What am I doing wrong?
>
Naming a column in your table the same name as the table is problematic
generally.  As for the query, if they are both intended to return the same
row the value Arbol is in the password column, not the nickname column.
You seem to have reversed the data for the two columns.

David J.

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

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Fri, Nov 22, 2024 at 1:07=E2=80=AFPM Arbol One &lt;<a h=
ref=3D"mailto:arbolone@hotmail.ca">arbolone@hotmail.ca</a>&gt; wrote:</span=
></div></div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" s=
tyle=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);pad=
ding-left:1ex"><div class=3D"msg-7920036085045288554">


<div dir=3D"ltr">
<div style=3D"font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color=
:rgb(0,0,0)"><span style=3D"font-size:12pt">The below sql statement produce=
s the right output</span></div><div style=3D"margin-top:1em;margin-bottom:1=
em;font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)=
">
SELECT nickname, password FROM password WHERE id=3D&#39;0938105618107N1&#39=
;;<br>
=C2=A0 nickname=C2=A0=C2=A0 | password<br>
-------------+----------<br>
=C2=A0Piccard@@21 |=C2=A0 Arbol<br>
(1 row)</div>
<div style=3D"margin-top:1em;margin-bottom:1em;font-family:Calibri,Helvetic=
a,sans-serif;font-size:12pt;color:rgb(0,0,0)">
However, if this sql statement produces the wrong output<br>
<b>SELECT nickname, password FROM password WHERE nickname=3D&#39;Arbol&#39;=
;<br>
=C2=A0nickname | password<br>
----------+----------<br>
(0 rows)</b></div>
<div style=3D"margin-top:1em;margin-bottom:1em;font-family:Calibri,Helvetic=
a,sans-serif;font-size:12pt;color:rgb(0,0,0)">
What am I doing wrong?</div></div></div></blockquote><div class=3D"gmail_de=
fault" style=3D"font-family:arial,helvetica,sans-serif">Naming a column in =
your table the same name as the table is problematic generally.=C2=A0 As fo=
r the query, if they are both intended to return the same row the value Arb=
ol is in the password column, not the nickname column.=C2=A0 You seem to ha=
ve reversed the data for the two columns.</div><div class=3D"gmail_default"=
 style=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=3D"g=
mail_default" style=3D"font-family:arial,helvetica,sans-serif">David J.</di=
v><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-se=
rif"><br></div></div></div>

--000000000000bd4d010627860382--