matching empty/uninitialized database entries

[Dr. Hawkins]

After inserting a new column into a postgres table, I'm unable to find
a way to match it in a query.

With the new column dTyp  CHAR(1) added, and set to "E" in a couple of places,

SELECT kywd FROM myTable WHERE dTyp=NULL;

should select all of the other entries, shouldn't it?

I've also tried
  WHERE dTyp=''
  WHERE dTyp !~ '[a-zA-Z]'

but none yield any results.

Even
  WHERE dTyp <> 'E';

yields no results.

Am I missing something obvious?

(I do get the correct result for "WHERE dTyp='E'"


-- 
Dr. Richard E. Hawkins, Esq.
(702) 508-8462