Return-Path: mer
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA19331; Wed, 10 Jun 92 16:33:08 -0700
Message-Id: <9206102333.AA19331@postgres.Berkeley.EDU>
From: mer@postgres.Berkeley.EDU
Subject: SQL syntax
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Date: Wed, 10 Jun 92 16:36:21 -0700
From: mer@postgres.Berkeley.EDU
X-Mts: smtp


I knew I was in dangerous waters...

I said:

> ... I believe sql (gulp - i hope i get this right)
> defines something like the keywords 'ISNULL' and 'NOTNULL' that appear after
> expressions:
>
>        where reln.attribute ISNULL
>
> or:
>
>        where reln.attribute NOTNULL

and it should have been...

> Actually, SQL uses "IS NULL" and "IS NOT NULL".
>
> e.g.:
>	SELECT emp.*
>	 WHERE emp.name = "Jeff"
>	   AND emp.heartswins IS NOT NULL;
>


Jeff Meredith
mer@postgres.berkeley.edu