Received: from lee.k12.nc.us (mail.lee.k12.nc.us [207.4.71.118]) by hub.org
	(8.8.8/8.7.5) with ESMTP id GAA25348 for <pgsql-sql@hub.org>;
	Sat, 27 Jun 1998 06:27:29 -0400 (EDT)
Received: by gateway.lee.k12.nc.us id <35713>; Fri, 26 Jun 1981 05:21:55 -0400
Date: Sat, 27 Jun 1998 06:29:30 -0400
From: James Olin Oden <joden@Lee.k12.nc.us>
X-Mailer: Mozilla 4.04 [en] (Win95; I)
MIME-Version: 1.0
To: Bruce Momjian <maillist@candle.pha.pa.us>
CC: pgsql-sql@hub.org
Subject: Re: [SQL] isnull function]
References: <199806261913.PAA01028@candle.pha.pa.us>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Message-Id: <81Jun26.052155edt.35713@gateway.lee.k12.nc.us>


> > Is there an isnull function avaliable in postgres, such as:
> >
> >   select isnull(dt_field, 'now') ...
> >
> > Thanks
> >
> >
>
> I don't tbink so, but it would be nice.  I think Ingres has it.  It also
> would not be hard to write as a loadable function.
>

Is it possible to do something like:

   select * from blah where x = ''

and get what he is asking for?

...james