Return-Path: owner-postman Delivery-Date: Thu, 05 May 94 18:53:02 -0700 Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id QAA04003 for postgres-redist; Thu, 5 May 1994 16:50:05 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199405052350.QAA04003@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from rz-wb.fh-sw.de (rz-wb.fh-sw.de [192.129.23.111]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id QAA03993 for ; Thu, 5 May 1994 16:50:01 -0700 Received: (root@localhost) by rz-wb.fh-sw.de (8.6.8/8.6.5) id BAA13413; Fri, 6 May 1994 01:49:35 +0200 Date: Fri, 6 May 1994 01:49:34 +0200 (MET DST) From: Michael Reifenberger Subject: Searching for empty String. To: postgres@postgres.Berkeley.EDU Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Thu, 05 May 94 16:50:05 -0700 Resent-XMts: smtp Hi. My first question to the list is: How can I retrieve for empty strings. After creating: create C (num=int4, name=text) and after reading in from a file I have: spog > retrieve (C.all) 124 (null) 2234 gfgfg 22 (null) Ok, so far, so good. Now if I do: retrieve (C.all) where C.name = "" I get no results but from my understanding it should be: 124 (null) 22 (null) Is this a bug or feature? Is the any way to retrieve empty (null) fields? Bye! .... Michael Reifenberger =============================================================================== To add/remove yourself 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. ===============================================================================