| From: | James Olin Oden <joden(at)Lee(dot)k12(dot)nc(dot)us> |
|---|---|
| To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | pgsql-sql(at)hub(dot)org |
| Subject: | Re: [SQL] isnull function] |
| Date: | 1998-06-27 10:29:30 |
| Message-ID: | 81Jun26.052155edt.35713@gateway.lee.k12.nc.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-sql |
> > 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1998-06-27 14:46:53 | Re: [HACKERS] Re: Odd behavior in regression test? |
| Previous Message | James Werwath | 1998-06-27 06:38:32 | URL type ? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dionisio Barrantes Blanco | 1998-06-29 18:37:17 | gmake not found |
| Previous Message | Bruce Momjian | 1998-06-27 02:11:56 | Re: [SQL] isnull function] |