| From: | "Nick Fankhauser" <nickf(at)ontko(dot)com> |
|---|---|
| To: | "Jeff Eckermann" <jeckermann(at)verio(dot)net>, <gserrato(at)sager(dot)telecom-co(dot)net>, <pgsql-general(at)postgresql(dot)org>, "Stephan Szabo" <sszabo(at)megazone23(dot)bigpanda(dot)com> |
| Subject: | RE: Appending null produces null? AND RE: [GENERAL] NVL (sql oracle) |
| Date: | 2000-11-09 18:04:57 |
| Message-ID: | NEBBLAAHGLEEPCGOBHDGMEOKCEAA.nickf@ontko.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Stephan Szabo wrote:
> If I'm not misremembering what NVL does, the equivalent
> is coalesce.
Sure enough!
... so the answer to the NVL question is that coalesce does it, and the
answer to Jeff Eckermann's question goes something like this:
test=> select * from hiho;
one |two
----+------
hiho|
hip |hop
|hophip
(3 rows)
test=> select one,two,coalesce(one,'')||coalesce(two,'') from hiho;
one |two |?column?
----+------+--------
hiho| |hiho
hip |hop |hiphop
|hophip|hophip
(3 rows)
Thanks Stephan!
-Nick
---------------------------------------------------------------------
Nick Fankhauser
Business:
nickf(at)ontko(dot)com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
Personal:
nickf(at)fankhausers(dot)com http://www.infocom.com/~nickf
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Eckermann | 2000-11-09 19:19:01 | RE: Appending null produces null? AND RE: [GENERAL] NVL (sql oracle) |
| Previous Message | Nelio Alves Pereira Filho | 2000-11-09 17:53:11 | storage procedures |