Wired behaviour from SELECT - Mailing list pgsql-general

From Arbol One
Subject Wired behaviour from SELECT
Date
Msg-id BYAPR12MB280818626E29A0CBC38DAEAABA232@BYAPR12MB2808.namprd12.prod.outlook.com
Whole thread Raw
Responses Re: Wired behaviour from SELECT
Re: Wired behaviour from SELECT
List 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?

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why?
Next
From: "David G. Johnston"
Date:
Subject: Re: Wired behaviour from SELECT