Re: "IS NOT NULL" != "NOT NULL"

"Gregory Wood" <gregw@com-stock.com> writes:
> db=> SELECT COUNT(*) FROM pkg_hosts WHERE timestamp_col NOT NULL;
>> | a_expr NOTNULL

> Are NOT NULL and NOTNULL really the same?

I assumed he meant "timestamp_col NOTNULL", because as given it would
certainly go no further than a parse error.

            regards, tom lane