Return-Path: owner-postman
Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id CAA10575 for postgres-redist; Thu, 13 Apr 1995 02:54:23 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199504130954.CAA10575@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from sunic.sunet.se (sunic.sunet.se [192.36.125.2]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with ESMTP id CAA10565 for <postgres@postgres.berkeley.edu>; Thu, 13 Apr 1995 02:54:17 -0700
Received: from cocos.fuw.edu.pl by sunic.sunet.se (8.6.8/2.03)
	id LAA29996; Thu, 13 Apr 1995 11:54:05 +0200
Received: from ccfs1.fuw.edu.pl by cocos.fuw.edu.pl (4.1/SMI-4.1)
	id AA14484; Thu, 13 Apr 95 11:53:57 +0200
Received: by ccfs1.fuw.edu.pl (4.1/SMI-4.1)
	id AA04097; Thu, 13 Apr 95 11:53:54 +0200
Date: Thu, 13 Apr 1995 11:53:53 +0200 (MET DST)
From: Kacper Nowicki <Kacper.Nowicki@fuw.edu.pl>
X-Sender: kacper@ccfs1
To: Postgres Mailing List <postgres@postgres.Berkeley.EDU>
Subject: Null values in where clause
Message-Id: <Pine.SUN.3.91.950413114821.1480G-100000@ccfs1>
Mime-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Thu, 13 Apr 95 02:54:22 -0700
Resent-XMts: smtp


Hi,

I would like to match in my query records with null value in one of int 
or text fields. How can I do that ? I tried sth like following, but it does 
not work :

retrieve (xx.all) where xx.i = null

I tried also 0, "" values but none of them match.

Thanks in advance,
Kacper

------------------------------------------------------------------------
Kacper Nowicki                         e-mail: Kacper.Nowicki@fuw.edu.pl
Warsaw University                      =================================
Physics Department Computer Center
Hoza 69, 00-681 Warszawa, Poland       fax:(48)(22)294309,(48)(2)6226154


==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================
              URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/