Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tEaOc-008Oez-Hi for pgsql-general@arkaria.postgresql.org; Fri, 22 Nov 2024 20:36:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tEaOa-00C8IW-MG for pgsql-general@arkaria.postgresql.org; Fri, 22 Nov 2024 20:36:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tEaOa-00C8IN-89 for pgsql-general@lists.postgresql.org; Fri, 22 Nov 2024 20:36:52 +0000 Received: from mail-ot1-x32e.google.com ([2607:f8b0:4864:20::32e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tEaOY-003L1L-1f for pgsql-general@postgresql.org; Fri, 22 Nov 2024 20:36:51 +0000 Received: by mail-ot1-x32e.google.com with SMTP id 46e09a7af769-7181285c7c4so1346846a34.0 for ; Fri, 22 Nov 2024 12:36:49 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1732307808; x=1732912608; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=VCRgkHjTC8+4aetbdJ2G1a07gvHq/gkfWsFMliU5Bi8=; b=G9NJNAcXhrMZjObSHG3bMavrVz4EsrzT6B3QnFfoNZMeQqRg8ajyKD/g3gv3KjdWqq 88v8a5LhoqXLorF1TpNHn0Z4pJk2UV8R8PMJbvWFIZMLx12tf9tUIxr65axgrvKAFAvY +ZRwyiw7b+jlL5TQ2sTU0Pm9d7KIExfeltVPzSpHlyUYyyZiNuSyx26kCnnKCO3kE49W 17JA/q/yyL3ndUp3cqJDloQRRJyxVm4O6FqGJlT6rXKq2MrSGd2f/QH/SAD4E0EM4YjZ W+nLGomKOGjOAzCumVkuI+/iCqt5z4LRTR4T06vRF8FHWdci1R4wdg2hcSwJYymL82TV g4Hg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1732307808; x=1732912608; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=VCRgkHjTC8+4aetbdJ2G1a07gvHq/gkfWsFMliU5Bi8=; b=dVllj66pOnO/jqGNpfoZLJclRMg1s1l8lFCJIIM0tuLaAomwljJFAGnLDioP06y0ql GTAD1xISxXEHIqd7dgKBAp9Xv4aX1JXqglTJkxI2GFKoOMhjmA66G62cz+Gmj2U4j7UR wF2SniOGjcGkGV7kDMNOrfdiLHfeqDletk7snTETHpgT2SBHOxvcxOOz0vZtL1rXiBKW LSxcE6ph1KhG+WaW45P87BFL3sOyK1Ivp2jjzgN0I6jFOOLbWOq0PXtnQ6NZevATfAUu df6ibJXzDEMtpgCC3C9aIxH+s/WDc7RXsV9RZZR0TI63uk51i2HNh9H3My41A1S5QvJd 6/+A== X-Gm-Message-State: AOJu0YyHfhzjrcBQquwCfNpgZ0s4ziT01+aMXoBGhhBSaE1ZT9KfcnV3 WtuXoWIpJ1JINUKOeFBUQLVlK+xGlHMHpqfz3beEnAJ8B1CyqXmv2LFk9BQlAAkKVO1IovgMXRU jmvi3Z8qrqEe1CaSs6NoC5Xx4cP4hOQ== X-Gm-Gg: ASbGncuWGcFGqI7Sm6j0m3R23E+1dHp1jX24oSZF0yz1wIWdDf7irRMgov5ZC+DNbvW b8Lgb1ue5T84pj7Hg4E2DTnYrhld8is2w X-Google-Smtp-Source: AGHT+IFHbYW1sWt77nP3kwTAVniOt8aMhpmZYlJX5A0LEweYD4v/r6otKlmK6xHp/OndNl3eP+gFJhXWds2LfA8+tIw= X-Received: by 2002:a05:6830:616:b0:718:109c:b733 with SMTP id 46e09a7af769-71c04ce4347mr4181354a34.29.1732307807735; Fri, 22 Nov 2024 12:36:47 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Fri, 22 Nov 2024 15:36:36 -0500 Message-ID: Subject: Re: Wired behaviour from SELECT To: pgsql-general Content-Type: multipart/alternative; boundary="00000000000085b2ec0627865794" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000085b2ec0627865794 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Fri, Nov 22, 2024 at 3:07=E2=80=AFPM Arbol One wro= te: > > 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) > Storing passwords in plain text is the Worst Possible Security Practice Ever Conceived. --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --00000000000085b2ec0627865794 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Fri, Nov 22, 2024 at 3:07=E2=80=AFPM A= rbol One <arbolone@hotmail.ca= > wrote:

Two different SELECT sql statem= ent don't behave the same way.
The below sql statement produces the right output
SELECT nickname, password FROM password WHERE id=3D'0938105618107N1'= ;;
=C2=A0 nickname=C2=A0=C2=A0 | password
-------------+----------
=C2=A0Piccard@@21 |=C2=A0 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!
--00000000000085b2ec0627865794--