Content-Type: multipart/alternative;
 boundary="------------UFO0kV4TlBK89PzAzryOxhb5"
Message-ID:
 <BYAPR12MB2808123244117AA0609BE85ABA2C2@BYAPR12MB2808.namprd12.prod.outlook.com>
Date: Sat, 23 Nov 2024 04:49:57 -0500
User-Agent: Mozilla Thunderbird
Subject: Re: Wired behaviour from SELECT
To: pgsql-general@lists.postgresql.org
References: <BYAPR12MB280818626E29A0CBC38DAEAABA232@BYAPR12MB2808.namprd12.prod.outlook.com>
 <CANzqJaAsWFExTg10+-dda-OZcPNTxHP63F74F=43nZG1pDTvrQ@mail.gmail.com>
Content-Language: es-ES, en-CA
From: Arbol One <ArbolOne@hotmail.ca>
Organization: ArbolOne
In-Reply-To: <CANzqJaAsWFExTg10+-dda-OZcPNTxHP63F74F=43nZG1pDTvrQ@mail.gmail.com>
MIME-Version: 1.0
X-MS-Exchange-MessageSentRepresentingType: 1
X-MS-PublicTrafficType: Email
X-MS-TrafficTypeDiagnostic: BYAPR12MB2808:EE_|BY1PR12MB8448:EE_
X-MS-Office365-Filtering-Correlation-Id: 136961e6-2215-4f64-b6ce-08dd0ba434c0
X-Microsoft-Antispam:
	BCL:0;ARA:14566002|8060799006|12050799009|461199028|5072599009|19110799003|7092599003|15080799006|3412199025|440099028;
X-Microsoft-Antispam-Message-Info:
	=?utf-8?B?TFhHd3JEaHlFOVFvVEthWllpVzdCRjZuNmlZT3NiN2dkQ2Eya0ZsWGZPaDh5?=
 =?utf-8?B?SFdYMTI2WHU5U3prMjhWdWZ5azRyemRiU2cxaWFhZGFUSjV1SWxVblNzM2RE?=
 =?utf-8?B?V0l0L3BXbmp3ZVpPK3hYaEJTdGplU2UxQkdhc1ZiaW5aVkt3aXhlallaVkkx?=
 =?utf-8?B?bXFNQ3lvOXhXaEJYMk45c0YzRkxRVGh3eUtWZHZpSkV3YmVJWjVDdWUzZ0d0?=
 =?utf-8?B?bi95azJxNGhOcGl1VTE4dVdva1JkUFpTN1VJcnZZQ3Yrc3QxWTF2aGVHR1dV?=
 =?utf-8?B?QVp4Q2dNU0pEa01KK1VmcXhYQyt5S2FRZU51djMvSE1jK3BQeDFvQTlkYVJS?=
 =?utf-8?B?citRRENWYU9JanU1VkF1dHVhSTNnNmYxbUVOZmE0bERiUlRWbCtaTG1ndndy?=
 =?utf-8?B?NjRmb0F6azlXN2MzZ29KMlAzeHVYVVhtWTAvNXVPeEw1Z290a05ldHNZRzhY?=
 =?utf-8?B?QjRrb2lWZkdLM2VKT2ZRZDZiYWVzTTRXQ0ZuMWYwbGRrU3l5NHlDWEJ1dWxs?=
 =?utf-8?B?TUhNL3c1TGkrU1A1OWk0Y1dULzlBY3R0dUJJbkZReDZlTysydUpTTGhodW5L?=
 =?utf-8?B?R2NiL2QxUjZsSWdJVUNhcHFpbUFTTk00aURjVERyaVVMbjA3cmlxOE1FWmJ6?=
 =?utf-8?B?V3JRRlpxSTNFdVg0eWt3WXpVVXhnZldYWmZoOXhhS0daeDlqZmFvZEI0elBQ?=
 =?utf-8?B?OWxTTUVzaDFPWEVVTUZlV2Uya0NZNFNHSjVjdnE3K2l2eU4rSFdRaVNyKzlx?=
 =?utf-8?B?Z0VwbFBWRVI1L3l0cVM0azNtMFQ0ZDhQZEJ4UXBNV2hIREdDZ3pWS1I2R1Jw?=
 =?utf-8?B?M1hOcW0yYy94cWhYN2ZHYkkwRHV2QWdGR2w1dEN5TzJYdC91eDlSRzFPZ1dl?=
 =?utf-8?B?UXRIU3VPWDV1R09ONlBzUlRZOHVMK2NOQ1diVUlFR0k5TFFqK2QxVUovUUJv?=
 =?utf-8?B?SGdjanZZbXovNEduRHBzNnlWbGNGcWdLMHJvdmMwU2IzeWhXSUN2OVBIVkUv?=
 =?utf-8?B?MWZXc2tidG42WTIvd1p6UmszdndpUVhHTFc2WGdHaFBaakd5eUIwb3B1YWtP?=
 =?utf-8?B?cmx1N2o2Z01YVTBTYWxtdlRVd0dOZzRGYXJ5Q05DVjV4ODBzdHJsNkwzUDJ4?=
 =?utf-8?B?U0ZRUjhOaXN6Wk16ZFlpaW9POG4zaTVCTGVTZHZIdDZHR2lBaHhvdENTUzBv?=
 =?utf-8?B?Z2Q2T3hWTGo5YnFPM1BwdXovd09idHZlenZKcCthaG55ckExbWplWDFvWGR4?=
 =?utf-8?B?SXRMRDB0T2ZTR3l3Znp5Nm1BTVZmN2NTZlZmejBjdzRtOGdoWDZXeXo5Y1Zh?=
 =?utf-8?B?TlJjdzYvNFpObHlmQncxWjNsOWtaV3ZScHFHQ214QnBOV1F3NXVhdVpUUnhu?=
 =?utf-8?B?ZWl6YmU3NTVCN3RoKzdTZzlTa05zcXR5MDExY0RNNFpnUWp6N3NFc1kwTTdu?=
 =?utf-8?Q?9vH+blNr?=
X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-MessageData-0:
	=?utf-8?B?WnNTQ0UxSTQ5NUxHTG1GR1RWZzFWSW1UYnpOUEF6a2FtRUFRdGtjTHdXRnhj?=
 =?utf-8?B?aGR6MDZJeVEzQWp1WFJKcHJPZWswVWlybExkcnZ3amdEYWhJQjY2c2xuVUU1?=
 =?utf-8?B?bEc4YzhUT0lIaFhzNG80UEhGMHU1aWdLMDdFMnFUa0JXTWtPSEkvZG13NERu?=
 =?utf-8?B?SFJjcjk4YzRVWEVJSW5hZUtkaXYwYzAzOEhkSFNFK0UzQU1KYi95R1pUNEl6?=
 =?utf-8?B?cDNxYUpDZFlKeEVjMDRwWTlnSUpVQ0p5cjJ2NEdDTVdPbEJCaTlaRlRKSU02?=
 =?utf-8?B?MmZlYml5bEtFbVlMK1FPK1QwcFVIdVBIanVtRkNPcEhVWFlMTEx4ZWJTWWdz?=
 =?utf-8?B?OXpIY0JTc3UxQlhmbG9KWEF3UWo5WGduUHFDb25hU3VKUk1EUW1Nbzhocnl3?=
 =?utf-8?B?cEsxRnR6SXZ3a1dDaU9iZGZkbDkzVlVhcGxzYWRUL1p5bGllb05yWUkyb0xI?=
 =?utf-8?B?dW1zbHhwYzdPWExGVmUvTDhyOHc1cHBQbkM5anUrcjMyMyt6OGlpSG03eFZr?=
 =?utf-8?B?K25VMUVGaXcxeHBrS0xaM0JkSHZzTmdKU2U3OUNudi8yK1ptL1Q2R1ZmOW02?=
 =?utf-8?B?Tkp1b21ZMm1VWFRoZVN1R2gydG54UkRvMEpyM1UweDBmc0szZXNydHZlbVFu?=
 =?utf-8?B?d0E5VzFwcngzQklZUHM3bEE5V0loSmdNZ0FLU2phZVZEVElIUjNFMjFUdzhr?=
 =?utf-8?B?UHM3MzI0WG5WcGtDMHp0WmtsaWxzRmx2UEpPczNFQU82NCs4V1hiek1iVVJh?=
 =?utf-8?B?ZTB0ZW1ETno3QVNEYi9jbGVpK0YrUFE0a05kVkdHNWNtamR0dzRXWjIvOGla?=
 =?utf-8?B?WndrN2pxSGFTMloyZHl4M0c4d285RmpCbW9Dc3JzdzNHVEJ0aXhoWkFoRnhZ?=
 =?utf-8?B?VjRiVjNNem9xTnhBdERPSDdGOHU2Yi9ISmowSk1BWFUzTUYwNmN6THE0L2Nk?=
 =?utf-8?B?UytqcVRMNm1WMGphMVdvL2lqNzdBc0l6L1VjaGlpZzA5MHRNRjlYSDFQdHRO?=
 =?utf-8?B?UHBYNXZBY2xMRXhkbUdMRFBadmJ1bi81ejRaMjhHbXpmV2xjdGpaOWVYYkVI?=
 =?utf-8?B?bzl6WWVYOTJhZGp0SEs2aHQwK1ExRHp2Vm9pQ3NPWnBGMU9OL1hMeEE3SVRP?=
 =?utf-8?B?elhKTEY0UkFKV1dwN3lVb0xBaVVHd1BJU1U5dU1FeC9uZ2Vaa2l4dzBMbHV4?=
 =?utf-8?B?bGZQeVJRQzUyNGk2NnlicnpjL2ljT3liUlVvOXRsNVAxQThCVlhYeFJpOWVJ?=
 =?utf-8?B?ckxocDdNajhCbUhzdXE0eGpWYm9WYktzaG5IT3MydUs3ZkxOdEQvRkI5bzlo?=
 =?utf-8?B?TURkL21aYnIvWVpGdFRxWFkwL01mSmRVd2dRRytSbXFLV2FMd2JxTjVhMHMx?=
 =?utf-8?B?eE1IeGxManZUM1Q0a2ZTNUp2Z0N3Sy9QRkxyUG5PTFBvY2Y1NmFud2Z4bWR4?=
 =?utf-8?B?cFZHU3R4UHg0U1Q0YThncXBBd2tDRFdjdGYxTU1Pa3dTUktXTS8xdFBnKzVT?=
 =?utf-8?B?aWlwU1hoUERmc2VNWk4vemVZVzgxd3FPWXQ0VEZwWmtOZW9lRWdrbEc2MFFZ?=
 =?utf-8?B?eEx3MGxmOWxlZTNvTHkyZUtPcitGWTVGbkRiK1YrRzlybzBDd2tIb3BLdjNh?=
 =?utf-8?Q?ImZt6OZyJ6D0xfhvSriYo5W0SuwRoLgMsMfHaPAzasgY=3D?=
X-OriginatorOrg: sct-15-20-7741-18-msonline-outlook-1cf9b.templateTenant
X-MS-Exchange-CrossTenant-Network-Message-Id: 136961e6-2215-4f64-b6ce-08dd0ba434c0
X-MS-Exchange-CrossTenant-AuthSource: BYAPR12MB2808.namprd12.prod.outlook.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-OriginalArrivalTime: 23 Nov 2024 09:50:04.8224
 (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: BY1PR12MB8448
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/BYAPR12MB2808123244117AA0609BE85ABA2C2%40BYAPR12MB2808.namprd12.prod.outlook.com>
Precedence: bulk

--------------UFO0kV4TlBK89PzAzryOxhb5
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Yes! Absolutely true. Thanks for the advice 🙂

On 2024-11-22 3:36 p.m., Ron Johnson wrote:
> On Fri, Nov 22, 2024 at 3:07 PM Arbol One <arbolone@hotmail.ca> wrote:
>
>
>     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='0938105618107N1';
>       nickname   | password
>     -------------+----------
>      Piccard@@21 |  Arbol
>     (1 row)
>
> Storing passwords in plain text is the Worst Possible Security 
> Practice Ever Conceived.
>
> -- 
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> lobster!
-- 
*/ArbolOne ™/*
Using Fire Fox and Thunderbird.
ArbolOne is composed of students and volunteers dedicated to providing 
free services to charitable organizations.
ArbolOne's development on Java, PostgreSQL, HTML and Jakarta EE is in 
progress [ í ]
--------------UFO0kV4TlBK89PzAzryOxhb5
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html><html data-lt-installed="true"><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body style="padding-bottom: 1px;">
    <p><font face="Helvetica, Arial, sans-serif">Yes! Absolutely true.
        Thanks for the advice </font>🙂</p>
    <div class="moz-cite-prefix">On 2024-11-22 3:36 p.m., Ron Johnson
      wrote:<br>
    </div>
    <blockquote type="cite" cite="mid:CANzqJaAsWFExTg10+-dda-OZcPNTxHP63F74F=43nZG1pDTvrQ@mail.gmail.com">
      
      <div dir="ltr">
        <div dir="ltr">On Fri, Nov 22, 2024 at 3:07 PM Arbol One &lt;<a href="mailto:arbolone@hotmail.ca" moz-do-not-send="true" class="moz-txt-link-freetext">arbolone@hotmail.ca</a>&gt;
          wrote:</div>
        <div class="gmail_quote">
          <blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
            <div class="msg1765055304075139144">
              <div dir="ltr">
                <div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
                  <br>
                </div>
                <div style="font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)"><span style="font-size:12pt">Two different SELECT sql
                    statement don't behave the same way.</span></div>
                <div style="margin-top:1em;margin-bottom:1em;font-family:Calibri,Helvetica,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='0938105618107N1';<br>
                  &nbsp; nickname&nbsp;&nbsp; | password<br>
                  -------------+----------<br>
                  &nbsp;Piccard@@21 |&nbsp; Arbol<br>
                  (1 row)</div>
              </div>
            </div>
          </blockquote>
          <div>Storing passwords in plain text is the Worst Possible
            Security Practice Ever Conceived.</div>
          <div><br>
          </div>
        </div>
        <span class="gmail_signature_prefix">-- </span><br>
        <div dir="ltr" class="gmail_signature">
          <div dir="ltr">Death to &lt;Redacted&gt;, and butter sauce.
            <div>Don't boil me, I'm still alive.<br>
              <div>
                <div>&lt;Redacted&gt; lobster!</div>
              </div>
            </div>
          </div>
        </div>
      </div>
    </blockquote>
    <div class="moz-signature">-- <br>
      <b><i>ArbolOne ™</i></b>
      <br>
      Using Fire Fox and Thunderbird.
      <br>
      ArbolOne is composed of students and volunteers dedicated to
      providing free services to charitable organizations.
      <br>
      ArbolOne's development on Java, PostgreSQL, HTML and Jakarta EE is
      in progress [ í ]</div>
  </body>
  <lt-container></lt-container>
</html>

--------------UFO0kV4TlBK89PzAzryOxhb5--