From: James Olin Oden <joden@Lee.k12.nc.us>
To: Bruce Momjian <maillist@candle.pha.pa.us>
Cc: pgsql-sql@hub.org
Subject: Re: [SQL] isnull function]
Date: Sat, 27 Jun 1998 06:29:30 -0400
Message-ID: <81Jun26.052155edt.35713@gateway.lee.k12.nc.us> (raw)
References: <199806261913.PAA01028@candle.pha.pa.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
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: pgsql-sql@postgresql.org
Cc: joden@Lee.k12.nc.us, maillist@candle.pha.pa.us, pgsql-sql@hub.org
Subject: Re: [SQL] isnull function]
In-Reply-To: <81Jun26.052155edt.35713@gateway.lee.k12.nc.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox