"Jim C. Nasby" <jim(at)nasby(dot)net> writes:> I build a table to test the theory that PGSQL wouldn't use an index to> satisfy 'SELECT * FROM table WHERE field IS NOT NULL'.
IS NULL/IS NOT NULL are not indexable operators.
regards, tom lane