| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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')
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2000-03-31 01:43:00 | Re: isnull |
| Previous Message | Tom Lane | 2000-03-31 00:11:49 | Re: isnull |