Re: Is this a feature ?

Thanks a lot for all the answers you gave me (Nick and the others). I didn't 
know about this function at all, and now, I'll be abble to write queries that 
fits my needs. Anyway, I don't use much of these as self queries with psql, 
since I code mostly with php, which provides concatenation functions that are 
more usefull for what I need. But now, I know why this is so, even for other 
SGBDR such as INFORMIX....
>
> coalesce( civ,'')||coalesce(name,'')||coalesce(forname,'')
>
> Regards,
>
> -Nick
>
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

-- 
David BOURIAUD
----------------------------------------------------------
In a world without walls or fences, what use do we have 
for windows or gates ?
----------------------------------------------------------
ICQ#102562021