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@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
Personal:
nickf@fankhausers.com http://www.infocom.com/~nickf