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 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 ; 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 X-Sender: kacper@ccfs1 To: Postgres Mailing List Subject: Null values in where clause Message-Id: 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/