Re: string not equal query, postgresql 9.4.4

On Thu, Sep 17, 2015 at 6:18 PM, John Scalia <jayknowsunix(at)gmail(dot)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.​