From: | David BOURIAUD <david(dot)bouriaud(at)ac-rouen(dot)fr> |
---|---|
To: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Is this a feature ? |
Date: | 2002-06-04 14:55:39 |
Message-ID: | 200206041655.39858.david.bouriaud@ac-rouen.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)postgresql(dot)org
--
David BOURIAUD
----------------------------------------------------------
In a world without walls or fences, what use do we have
for windows or gates ?
----------------------------------------------------------
ICQ#102562021
From | Date | Subject | |
---|---|---|---|
Next Message | James Orr | 2002-06-04 15:14:36 | Re: Is this a feature ? |
Previous Message | Nick Fankhauser | 2002-06-04 14:38:53 | Re: Is this a feature ? |