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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gregory Wood" <gregw(at)com-stock(dot)com>
Cc: "PostgreSQL-General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: "IS NOT NULL" != "NOT NULL"
Date: 2002-01-18 20:06:33
Message-ID: 9708.1011384393@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Gregory Wood" <gregw(at)com-stock(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2002-01-18 20:09:31 Re: How to determine which are "idle in transaction"
Previous Message Bill Cunningham 2002-01-18 20:03:50 Re: large file limitation