Wired behaviour from SELECT

Поиск
Список
Период
Сортировка
От Arbol One
Тема Wired behaviour from SELECT
Дата
Msg-id BYAPR12MB280818626E29A0CBC38DAEAABA232@BYAPR12MB2808.namprd12.prod.outlook.com
обсуждение исходный текст
Ответы Re: Wired behaviour from SELECT
Re: Wired behaviour from SELECT
Список 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 по дате отправления: