John Scalia wrote: > I'm believing something here may be something incorrect with my setup, but here's the output from \d+ > results > > Table "public.results" > Column | Type | Modifiers | Storage | Stats target | > Description > instrument | character varying(10) | not null | extended | | > date | character varying(15) | not null | extended | | > result | character(4) | not null | extended | | > > The table has six rows: > > Instrument | date | result > -----------------+-------------------+---------- > visc100 | 01/01/2015 | PASS > visc60 | 01/01/2015 | FAIL > visc60pre | 01/01/2015 | 6FB3 > visc60post | 01/01/2015 | 7F5A > density | 01/01/2015 | PASS > base | 01/01/2015 | PASS > > The last query I ran was: > > 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? Not really... What does the execution plan look like: EXPLAIN (VERBOSE, COSTS off) SELECT * FROM results where result <> 'PASS'; What do you get for SHOW lc_collate; SHOW lc_ctype; Maybe some problem with your locale... Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
