Re: Is this a feature ?

On Tue, 4 Jun 2002, David BOURIAUD wrote:

I think is indeed is a feature!

Use coalesce.


> Hi the list !
> I've read the docs, and found that you could concatenate two or more strings 
> in one select statement like this :
> select
>     civ || name || forname as identity
> from
>     person;
> 
> This just works fine and returns rows with only one column named identity.
> So far, if one of the fields (civ, name or forname) is null, identity is 
> null... That doesn't seems right, since it means that 1+2+0 = 0 !!!!
> Has anybody else seen the same strange behaviour ? And is there a way to work 
> this around ?
> Please, don't answer me to use the function textcat (text, text), since it 
> behaves the same and makes queries quite unreadeable...
> eg.
> select 
>     textcat ( textcat (civ, name), forname) as identity
> from person;
> is quite readeable, but when you add fields separator, it isn't.
> 

-- 
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
tel:    +30-10-8981112
fax:    +30-10-8981877
email:  achill@matrix.gatewaynet.com       mantzios@softlab.ece.ntua.gr