From: David BOURIAUD <david.bouriaud@ac-rouen.fr>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: Is this a feature ?
Date: Tue, 4 Jun 2002 16:55:39 +0200
Message-ID: <200206041655.39858.david.bouriaud@ac-rouen.fr> (raw)
In-Reply-To: <NEBBLAAHGLEEPCGOBHDGIEBLFBAA.nickf@ontko.com>
References: <NEBBLAAHGLEEPCGOBHDGIEBLFBAA.nickf@ontko.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: david.bouriaud@ac-rouen.fr
Subject: Re: Is this a feature ?
In-Reply-To: <200206041655.39858.david.bouriaud@ac-rouen.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox