Postgres Pro
Downloads
Home   >   mailing lists

Re: "IS NOT NULL" != "NOT NULL" - Mailing list pgsql-general

From Tom Lane
Subject Re: "IS NOT NULL" != "NOT NULL"
Date
Msg-id 9708.1011384393@sss.pgh.pa.us
Whole thread Raw
In response to Re: "IS NOT NULL" != "NOT NULL"  ("Gregory Wood" <gregw@com-stock.com>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Postgresql monitoring question
Next
From: Doug McNaught
Date:
Subject: Re: PL/pgSQL examples?