Wired behaviour from SELECT
Arbol One <arbolone@hotmail.ca>
From: Arbol One <arbolone@hotmail.ca>
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>, PostGreSQL MailingList <pgsql-general@postgresql.org>
Date: 2024-11-22T20:07:10Z
Lists: pgsql-general
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) However, if this sql statement produces the wrong output SELECT nickname, password FROM password WHERE nickname='Arbol'; nickname | password ----------+---------- (0 rows) What am I doing wrong?