From: Arbol One <arbolone@hotmail.ca>
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>,
	PostGreSQL MailingList <pgsql-general@postgresql.org>
Subject: Wired behaviour from SELECT
Thread-Topic: Wired behaviour from SELECT
Thread-Index: AQHbPRm2a8iV4neSgUy+0xBQlDKuSA==
Date: Fri, 22 Nov 2024 20:07:10 +0000
Message-ID:
 <BYAPR12MB280818626E29A0CBC38DAEAABA232@BYAPR12MB2808.namprd12.prod.outlook.com>
Accept-Language: en-CA, en-US
Content-Language: en-CA
msip_labels:
x-ms-exchange-messagesentrepresentingtype: 1
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: BYAPR12MB2808:EE_|MW4PR12MB6683:EE_
x-ms-office365-filtering-correlation-id: 6346826d-989f-4299-33a0-08dd0b313fdb
x-ms-exchange-slblob-mailprops:
 igNrEvV8uhHj6Y23PWldRtzMgCDNfjZ/omljKFSFQPdwSsLXVuU0HPItmzW3f1sNNIEk4nbJ+6eP1AG1XU234aepjQHgVcBM0t+qz+u3PrTK/NbVd4Vc3IPBcdVVxXY3GJjAj2K1nh7r5OaPI7rlFH2phcjnNy9+mf0gtLabvL3yrjhIq4omz7EV+NMkV19OeyfFxhuyP753W7crJJx2npn/XJPsf8oFfYcsCVdYLCm4ix7hjqYtIWbwRm16ozx8J6yiZYdShlnuyxo/EGBtVaJYWSjodXiFqgoWT++dyyiaDJJtV5i/6OKspSqjFc45H98bCIvgjQ2KQvaTICfoOQutKWPSR5eGZB9qZp3zp16NWVakA4oJS0LkVqNNoB7xmt5f7CLuOURLpiN6iQXVi+eFfhqRuL2EbzFCoDAV961p8VPQ22fu8v9ouOAZLJ/3e+yXtT7L83/eWVpxPFWJqMwrq9p7cR1JswReugIb7w3jrcoS8vk9dLvXTSP3JPr8np0TScRCOOeHYu9g5Z4iMHDGNbDXEXXarSZc/qm5gU35e/L5rvTuZslDAGkLZr192xbJ211xkStuHXGvrDAfBlzfSDv3zbUwJ0J4GPhtrczBryhynmggQGqrFJ2j/u5d/mZhADhqBMgsKwVSsMS9lBdMKQq4iaHXXWpebHjjfR/bJs6K4wKLEPgkbTMaNOKy3xN38fnVu0Y=
x-microsoft-antispam:
 BCL:0;ARA:14566002|8062599003|461199028|15030799003|19110799003|7092599003|15080799006|8060799006|3412199025|440099028|102099032;
x-microsoft-antispam-message-info:
 =?iso-8859-1?Q?x44krnPYpzRXMMAfXDZAQn9pU9NNhfKl3q4TLF5KHF3qeuwcr+/WsIikhc?=
 =?iso-8859-1?Q?SG45Du6BlT8HnurOwi+zSKVQ+VwmKnuAX6c9CkUVfpwhbO8flpVhPT/lxr?=
 =?iso-8859-1?Q?89T0W3oOMGo5l1+j0LAliH0FdGF8aGtmEAjsASV646az5NgOuc81VWvhz6?=
 =?iso-8859-1?Q?0fx8JAuAi9/VaVhB6nIg0txwBLd9v3inyVh07jX3cX0hBXY8lnPi+6A73z?=
 =?iso-8859-1?Q?rzwQALX7iowjcbIJ4u91bbBLbKdeFk0SfzaBB5D41vo1nSFEQjHFHP79T1?=
 =?iso-8859-1?Q?6Jg4zy1qYxdQHwWBfnyDZoZzK1zdlT3VF9Kx48TDGzIbsCJecmElxV4/3S?=
 =?iso-8859-1?Q?HUwNQgR5KnEIvZqpRVZ0O5GQx+Bc9QKZGrmUyIh1bY3E+DR+dl1QZWatEC?=
 =?iso-8859-1?Q?mAGx5wTZOcF3bYpB3aM1nPG47ZHnmVqGzhi7ISAtSXUwuJWQBqTvCrTo2T?=
 =?iso-8859-1?Q?HQhlLVE/L6sSaTJp+55fcG8oLXzMFyHW2NzEtinGRUgWCtZMcsf0bx9Ebg?=
 =?iso-8859-1?Q?6D25zdZ2bx1vyfylzT5qI2jaF+pEoiMPb+6NqyYPNtC8ESJEXLnNoRCWMt?=
 =?iso-8859-1?Q?LtL1w/YfeYVC7RHsfW5nnDE8KKYIpmPDtH9lGrOOWN+gmnXW050+vNLCFR?=
 =?iso-8859-1?Q?aUaaTu61LmKPJ33aJZzzW6W5dFUZ68O+gpZfhPlEukEZHpihSpQfdyj1mI?=
 =?iso-8859-1?Q?dJ4R5XbRGPDLgYbFEiCmbH9ryRIahZGgg4XExk5IT4DV+mxxp5FSQEStT9?=
 =?iso-8859-1?Q?BjVVfKbswrVyImC5GuoBSxJ6CaQUmtuCTDxT0I/BapIbROUXGXS227zviu?=
 =?iso-8859-1?Q?OlMAUNHR/+hpQMEtebLrT63d4yAV4SROkR2lS9qsJ+SMcMt989sTMo3TOD?=
 =?iso-8859-1?Q?6uzfymQGWNwDOFgGVRcSHd5GEL3SvPcOgDVZ7E8JwnoKMir9RRmDGSQC2J?=
 =?iso-8859-1?Q?znZoiZD5tbtp/BZxCh0SdMsJ4NeFkdP+rYiogBf8GRetqg2XW9Ad9doW9k?=
 =?iso-8859-1?Q?tlAgEBD1njfAgfjoN9NeWE6cEinTXoz8Rr41weSTY0P6FeE7qJk+OA5/e3?=
 =?iso-8859-1?Q?rGvuAqPC0Z51xEcbA7lIAEUeLCZoEwQAU9LZAm8beQt3?=
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?iso-8859-1?Q?pVyI7GoiEhFkfPZI0TE0snEWdRJujZjdvrIzqWfPmjrOQU/6Bg9wuXdMYm?=
 =?iso-8859-1?Q?7ps5wQ4nsLRSGjFgxO2F/0I+Q5uSAfbDJY1o0VvZe8CJldxRf25J4MBgqU?=
 =?iso-8859-1?Q?rPEQ3LTE1EYr7oKDP1y/lVLmFmvpvq5JBgS2zb4kq43CzTNHBO88/uiEK9?=
 =?iso-8859-1?Q?e36QM76Ls9/4OHon8V79TMrqaPm5bT7yJ4WBhbaPyM8WGXu3L825DCUD4J?=
 =?iso-8859-1?Q?mn+nloC1rKwuf8N4fSS+Kdp1syMfgHasg+6Oe6Cwd3yUNBMGvc3Soff70q?=
 =?iso-8859-1?Q?k2cWWPuQONgNkx+vcqk4Pjbqm04DdjncnLsVcbNCk7QFIAjdL271b4nHKI?=
 =?iso-8859-1?Q?L2eYG5RBZOaXkPo8KWWVmLjpJ3WMl0cbHqhKBsHj0o80JyZ3sN2EqGO5e2?=
 =?iso-8859-1?Q?1Tu2IeDGUMqJDuIt37eo4xsK5X97a1rrFFsAvqihH7LmvDWfcvPsLnM8om?=
 =?iso-8859-1?Q?uOW+wvTYtGo4NCG7VSwsD6N/gPmc1VcvLyKaU4c9TFHH1THtSo8ajOQx5+?=
 =?iso-8859-1?Q?D1MlbRbrEFnroKuQ9yImYE8i+Dg8kuiJMbI7l5+0niYnWJpGR+LrcCAYTB?=
 =?iso-8859-1?Q?b+XUpjOx0ViFQ5GwPxlaHvyBsMQk++4+pYuUaEnizfILpPPPZswo9jBV6E?=
 =?iso-8859-1?Q?N88SUreYZxLuRHUxsJA30dscollBfG3Q+LajYz9kDvjQtRXqBoGspOk9L/?=
 =?iso-8859-1?Q?NLkI1JiPvsI9ig5oGJpjkq78z0kU/j0LaTaggJqLKXYgk1WX2u2m3Q9QAp?=
 =?iso-8859-1?Q?EDezQctKrfq4rhu51oLPIit4LqBNqIq/tuHwsXxE7P9VR8ckNiJ77HnWQM?=
 =?iso-8859-1?Q?xTaUhGyyHOIyCAPeZcFXXtXRTnnTlBhu3VeyAi2Iw4iCB8efNraB0RS0X3?=
 =?iso-8859-1?Q?x4asUq8rodC2Npx1l/GdIeK24e3lwlJwy9D8cL7Hcoo3Rz+euUrJb5pZil?=
 =?iso-8859-1?Q?qdIeT0X7yFppdZvaFQJ2i1F7NjWaxGdTyI2faiN1Ca9ae9mv6DDWgnZGn3?=
 =?iso-8859-1?Q?pgquU00OVRz/O75rU/IKNOTt+regzfzp4DRntNa8Mo0CyW1iyFdwqjw6BO?=
 =?iso-8859-1?Q?D8SmrWRQrrcChUuFsAAkOZGTedlIcAH2Paq7c/NUE8tjQ7IhQu1iYlBjFH?=
 =?iso-8859-1?Q?UEQJNLV6M/ubzWSpcrbCGjcU9ByoBunb9chJZzZEqypASO71ytUFeWscag?=
 =?iso-8859-1?Q?IBQXKMpmoyvOxAgWANGbRbU/d0gORGAvvfkxj5AvYYab32tljZWkX87w9q?=
 =?iso-8859-1?Q?758S3d20t/FWuKPhcqPA=3D=3D?=
Content-Type: multipart/alternative;
	boundary="_000_BYAPR12MB280818626E29A0CBC38DAEAABA232BYAPR12MB2808namp_"
MIME-Version: 1.0
X-OriginatorOrg: sct-15-20-7741-18-msonline-outlook-1cf9b.templateTenant
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: BYAPR12MB2808.namprd12.prod.outlook.com
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000
X-MS-Exchange-CrossTenant-Network-Message-Id: 6346826d-989f-4299-33a0-08dd0b313fdb
X-MS-Exchange-CrossTenant-originalarrivaltime: 22 Nov 2024 20:07:10.8598
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped: MW4PR12MB6683
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/BYAPR12MB280818626E29A0CBC38DAEAABA232%40BYAPR12MB2808.namprd12.prod.outlook.com>
Precedence: bulk

--_000_BYAPR12MB280818626E29A0CBC38DAEAABA232BYAPR12MB2808namp_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Two different SELECT sql statement don't behave the same way.
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';
 nickname | password
----------+----------
(0 rows)
What am I doing wrong?


--_000_BYAPR12MB280818626E29A0CBC38DAEAABA232BYAPR12MB2808namp_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none;"> P {margin-top:0;margin-bo=
ttom:0;} </style>
</head>
<body dir=3D"ltr">
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"margin-top: 1em; margin-bottom: 1em;=
 font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0=
, 0, 0);">
Two different SELECT sql statement don't behave the same way.</div>
<div style=3D"margin-top: 1em; margin-bottom: 1em; font-family: Calibri, He=
lvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
The below sql statement produces the right output<br>
SELECT nickname, password FROM password WHERE id=3D'0938105618107N1';<br>
&nbsp; nickname&nbsp;&nbsp; | password<br>
-------------+----------<br>
&nbsp;Piccard@@21 |&nbsp; Arbol<br>
(1 row)</div>
<div style=3D"margin-top: 1em; margin-bottom: 1em; font-family: Calibri, He=
lvetica, 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'Arbol';<br>
&nbsp;nickname | password<br>
----------+----------<br>
(0 rows)</b></div>
<div style=3D"margin-top: 1em; margin-bottom: 1em; font-family: Calibri, He=
lvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
What am I doing wrong?</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id=3D"Signature" class=3D"elementToProof"></div>
</body>
</html>

--_000_BYAPR12MB280818626E29A0CBC38DAEAABA232BYAPR12MB2808namp_--