agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Paul M. Aoki <aoki@postgres.Berkeley.EDU>
To: Michael Reifenberger <root@rz-wb.fh-sw.de>
Cc: postgres@postgres.Berkeley.EDU
Subject: Re: Searching for empty String.
Date: Thu, 05 May 94 17:19:46 -0700
Message-ID: <199405060019.RAA23132@faerie.CS.Berkeley.EDU> (raw)
In-Reply-To: <Pine.3.89.9405060148.A13380-0100000@rz-wb.fh-sw.de>

Michael Reifenberger <root@rz-wb.fh-sw.de> writes:
> Is the any way to retrieve empty (null) fields?

null is not the same as an empty string.

if your fields contain zero-length strings, the query you gave (where 
foo.bar = "") will retrieve them.

if your fields contain null, you should use the ISNULL and NOTNULL
keywords as documented in the manual.
--
  Paul M. Aoki  |  CS Div., Dept. of EECS, UCB  |  aoki@postgres.Berkeley.EDU
                |  Berkeley, CA 94720           |  ...!uunet!ucbvax!aoki

===============================================================================
    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: aoki@postgres.Berkeley.EDU, root@rz-wb.fh-sw.de
  Subject: Re: Searching for empty String.
  In-Reply-To: <199405060019.RAA23132@faerie.CS.Berkeley.EDU>

* 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