Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA19693; Fri, 20 Aug 93 20:51:41 -0700
Message-Id: <9308210351.AA19693@postgres.Berkeley.EDU>
From: Ravi Lingam <lnj@earth.cse.fau.edu>
Subject: Re: Can you match on (null)?
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
To: weingart@inf.ethz.ch
Date: Sat, 21 Aug 93 0:03:33 EDT
Cc: postgres@postgres.Berkeley.EDU
In-Reply-To: <9308201315.AA14783@postgres.Berkeley.EDU>; from "weingart@inf.ethz.ch" at Aug 20, 93 3:23 pm
X-Mailer: ELM [version 2.3 PL11]

Tobias Weingartner (weingart@inf.ethz.ch) writes:
> * retrieve (x.Login, x.Cdate, x.Edate) from x in Userdb
> 	where x.Edate = NULL \g
> 
> This returns nothing.
Try this 
 * retrieve (x.Login, x.Cdate, x.Edate) from x in Userdb
	where x.Edate ISNULL \g

to check if x.Edate is NULL and for NOT NULL try

 * retrieve (x.Login, x.Cdate, x.Edate) from x in Userdb
	where x.Edate NOTNULL \g

I hope the above queries will solve you problem. 

-Ravi Lingam