Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 5E5C1475933
	for <pgsql-sql@postgresql.org>; Tue,  6 Aug 2002 04:37:16 -0400 (EDT)
Received: from mta05-svc.ntlworld.com (mta05-svc.ntlworld.com [62.253.162.45])
	by postgresql.org (Postfix) with ESMTP id 90583475872
	for <pgsql-sql@postgresql.org>; Tue,  6 Aug 2002 04:37:15 -0400 (EDT)
Received: from Wilbur ([80.2.246.217]) by mta05-svc.ntlworld.com
	(InterMail vM.4.01.03.27 201-229-121-127-20010626) with SMTP
	id <20020806083716.TMHC28874.mta05-svc.ntlworld.com@Wilbur>;
	Tue, 6 Aug 2002 09:37:16 +0100
Message-ID: <007901c23d24$7843c720$0500a8c0@Wilbur>
From: "Julian Scarfe" <julian.scarfe@ntlworld.com>
To: "Archibald Zimonyi" <archie@netg.se>
Cc: <pgsql-sql@postgresql.org>
References: <Pine.LNX.4.44.0208061027250.8514-100000@elvegris.netg.se>
Subject: Re: Concatenate aggregate?
Date: Tue, 6 Aug 2002 09:37:16 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200208/82
X-Sequence-Number: 8928

From: "Archibald Zimonyi" <archie@netg.se>

> One way is to create your own aggregate function. See the reference manual
> under CREATE AGGREGATE.

Thank you.

http://www.postgresql.org/idocs/index.php?sql-createaggregate.html

And indeed Chris's LIST() aggregate does almost exactly what I want.  I
don't think it was there last time I tried to figure out CREATE AGGREGATE.
The examples on that page are very helpful.

Julian