| From: | Arbol One <arbolone(at)hotmail(dot)ca> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, PostGreSQL MailingList <pgsql-general(at)postgresql(dot)org> |
| Subject: | Wired behaviour from SELECT |
| Date: | 2024-11-22 20:07:10 |
| Message-ID: | BYAPR12MB280818626E29A0CBC38DAEAABA232@BYAPR12MB2808.namprd12.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2024-11-22 20:12:46 | Re: Wired behaviour from SELECT |
| Previous Message | Adrian Klaver | 2024-11-22 17:18:31 | Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? |