Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id CD7D42E3FD3
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 21 Dec 2007 08:31:22 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 46104-02-3 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 21 Dec 2007 08:31:11 -0400 (AST)
Received: from mail46.e.nsc.no (mail46.e.nsc.no [193.213.115.46])
	by postgresql.org (Postfix) with ESMTP id ED52A2E3FEC
	for <pgsql-sql@postgresql.org>; Fri, 21 Dec 2007 08:31:16 -0400 (AST)
Received: from [192.168.0.57] (062016190089.customer.alfanett.no
	[62.16.190.89]) (authenticated bits=0)
	by mail46.nsc.no (8.13.8/8.13.5) with ESMTP id lBLCVEaR004107
	for <pgsql-sql@postgresql.org>; Fri, 21 Dec 2007 13:31:14 +0100 (MET)
From: "Leif B. Kristensen" <leif@solumslekt.org>
To: pgsql-sql@postgresql.org
Subject: Re: Concatenation through SQL
Date: Fri, 21 Dec 2007 13:31:14 +0100
User-Agent: KMail/1.9.7
References: <6C0CF58A187DA5479245E0830AF84F42337F97@poweredge.attiksystem.ch>
	<200712211216.45186.leif@solumslekt.org>
	<520638AC-01E3-48C6-A480-DEB5E56139E5@tele2.se>
In-Reply-To: <520638AC-01E3-48C6-A480-DEB5E56139E5@tele2.se>
X-Face: %iea8o"[SI'kMDS.`hz7lU=?\^lC9J-]CVjo;
	f{4-C:$?uVUEjyN~uYFn%*aH_c3d09U>=?utf-8?q?x=0A=09TXtaoj=7EMV=2E8PgG7hik9=3BcCT2N6+u?=@Y{wH\p3*_f~FH9k,Wi74e[_l%.7b^'zJ)8S'^G<(=?utf-8?q?=3D=0A=09zw8=5CPMC3=27=7BKl9=2EzL*ks!b6wA?=,c~'F`k&Vq|ELDGa|4<sl_DHXENz#~X_1qmPq+W;
	1LY2D9
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200712211331.14239.leif@solumslekt.org>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200712/112
X-Sequence-Number: 29804

On Friday 21. December 2007, Niklas Johansson wrote:

>select array_to_string(array[given, patronym, toponym], ' ') from
>persons where person_id=3D57;
>
>Notice the use of the array[] constructor, instead of the array()
>constructor, which must be fed a subquery which returns only one
> column.

Aah, great!

pgslekt=3D> select array_to_string(array[given, patronym, toponym], ' ')=20
from persons where person_id=3D57;
     array_to_string
=2D-------------------------
 Abraham Jonsen Bj=F8rntvet
(1 row)

Tackar och bockar!
=2D-=20
Leif Biberg Kristensen | Registered Linux User #338009
http://solumslekt.org/ | Cruising with Gentoo/KDE
My Jazz Jukebox: http://www.last.fm/user/leifbk/