Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id DDB3E475E36 for ; Tue, 4 Jun 2002 10:50:23 -0400 (EDT) Received: from necker.ac-rouen.fr (smtp.ac-rouen.fr [194.167.110.3]) by postgresql.org (Postfix) with ESMTP id C21FB475E35 for ; Tue, 4 Jun 2002 10:50:16 -0400 (EDT) Received: from s2ia27 (localhost.localdomain [127.0.0.1]) by necker.ac-rouen.fr (8.11.0/8.11.0) with ESMTP id g54EoL624281 for ; Tue, 4 Jun 2002 16:50:21 +0200 Content-Type: text/plain; charset="iso-8859-1" From: David BOURIAUD Organization: Inspection =?iso-8859-1?q?acad=E9mique=20de?= l'Eure To: "pgsql-sql@postgresql.org" Subject: Re: Is this a feature ? Date: Tue, 4 Jun 2002 16:55:39 +0200 X-Mailer: KMail [version 1.4] References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200206041655.39858.david.bouriaud@ac-rouen.fr> X-Archive-Number: 200206/28 X-Sequence-Number: 7993 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