Re: string not equal query, postgresql 9.4.4

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: string not equal query, postgresql 9.4.4
Дата
Msg-id CAKFQuwawTZkzW75hfU_shS-_uEW7AGw83b_G0ZuWNc6+TFLcXw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: string not equal query, postgresql 9.4.4  (John Scalia <jayknowsunix@gmail.com>)
Ответы Re: string not equal query, postgresql 9.4.4  (John Scalia <jayknowsunix@gmail.com>)
Список pgsql-admin
On Thu, Sep 17, 2015 at 6:18 PM, John Scalia <jayknowsunix@gmail.com> wrote:

SELECT * FROM results where result <> 'PASS';

and it produced all the rows, not just the ones beginning with visc60 that I expected. Based on what you had written, I should have seen the correct output. So, any ideas?

​EXPLAIN ANALYZE SELECT * FROM results WHERE result <> 'PASS';

What happens when you run the following?  Do you see the same incorrect behavior?

WITH vals (v) AS (
VALUES ('PASS'::char(4)), ('FAIL'::char(4))
)
SELECT 
​DISTINCT ​
*
FROM vals
WHERE v <> 'PASS'::char(4);

David J.​
 

В списке pgsql-admin по дате отправления:

Предыдущее
От: John Scalia
Дата:
Сообщение: Re: string not equal query, postgresql 9.4.4
Следующее
От: John Scalia
Дата:
Сообщение: Re: string not equal query, postgresql 9.4.4