Skip site navigation (1) Skip section navigation (2)

Re: isnull

From: Julie Hunt <jhunt(at)chac(dot)qld(dot)edu(dot)au>
To: Joseph Shraibman <jks(at)p1(dot)selectacast(dot)net>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: isnull
Date: 2000-03-31 01:10:42
Message-ID: 38E3FB11.DF2AACE0@chac.qld.edu.au (view raw or flat)
Thread:
Lists: pgsql-sql
Could you describe exactly what you are trying to achieve and the select statement
with the case you tried.

Joseph Shraibman wrote:

>
>
> I've actually taken a closer look at the web page and not only did the name change,
> but I now notice that they change what it is supposed to do as well.  It does work
> as currently defined, but I needed something that does what the original
> documentation said:
>
> IFNULL(input,non-NULL substitute)
>  return second argument if first is NULL
>  Example:        IFNULL(c1, 'N/A')


In response to

  • Re: isnull at 2000-03-30 23:07:16 from Joseph Shraibman

pgsql-sql by date

Next:From: Bruce MomjianDate: 2000-03-31 01:43:00
Subject: Re: isnull
Previous:From: Tom LaneDate: 2000-03-31 00:11:49
Subject: Re: isnull

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group