agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Michael Reifenberger <root@rz-wb.fh-sw.de>
To: postgres@postgres.Berkeley.EDU
Subject: Searching for empty String.
Date: Fri, 6 May 1994 01:49:34 +0200 (MET DST)
Message-ID: <Pine.3.89.9405060148.A13380-0100000@rz-wb.fh-sw.de> (raw)

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.
===============================================================================

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: root@rz-wb.fh-sw.de
  Subject: Re: Searching for empty String.
  In-Reply-To: <Pine.3.89.9405060148.A13380-0100000@rz-wb.fh-sw.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox