| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Esa Pikkarainen <epikkara(at)ktk(dot)oulu(dot)fi> |
| Cc: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: If test in sql?? |
| Date: | 2001-01-25 15:46:02 |
| Message-ID: | 20010125094602.C12171@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Jan 25, 2001 at 10:01:21AM +0200,
Esa Pikkarainen <epikkara(at)ktk(dot)oulu(dot)fi> wrote:
> Thank you very much. Fine! Just two little questiton s more:
>
> 1) Can COALESCE take more than two alternatives?
>
> 2) Does it treat a zero length string as NULL or NOT NULL?
Wouldn't it have been faster to fire up psql and try a select to see what
the answer is than send a message to this list?
COALESCE definitely works with more than 2 values, as I use it that way.
'' should not be the same as a null, but I haven't actually tested this
to make sure it works that way.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Mercer | 2001-01-25 16:03:32 | experience with replication? |
| Previous Message | Bruno Wolff III | 2001-01-25 15:28:01 | Re: Re: 7.1 expected features list? |