Home > mailing lists

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

From	Gregory Wood
Subject	Re: "IS NOT NULL" != "NOT NULL"
Date	January 18, 2002 17:50:20
Msg-id	003f01c1a056$8a33d990$7889ffcc@comstock.com Whole thread Raw
In response to	"IS NOT NULL" != "NOT NULL" (Sean Chittenden <sean@chittenden.org>)
Responses	Re: "IS NOT NULL" != "NOT NULL" (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-general

> > db=> SELECT COUNT(*) FROM pkg_hosts WHERE timestamp_col NOT NULL;

>         | a_expr NOTNULL

Are NOT NULL and NOTNULL really the same?

Greg

From: "Peter Bayley"
Date: 18 January 2002, 17:40:40
Subject: Recover an existing database

From: Mike Bridge
Date: 18 January 2002, 17:50:23
Subject: How to determine which are "idle in transaction"