X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 44BE6D1B183 for ; Mon, 2 Aug 2004 10:00:48 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 05062-01 for ; Mon, 2 Aug 2004 13:00:48 +0000 (GMT) Received: from mail.sells.com (mail.sells.com [204.107.136.10]) by svr1.postgresql.org (Postfix) with ESMTP id 8E55FD1B17B for ; Mon, 2 Aug 2004 10:00:41 -0300 (ADT) Received: from [192.168.5.55] (192.168.5.55) by mail.sells.com with ESMTP (Eudora Internet Mail Server 3.2.5) for ; Mon, 2 Aug 2004 08:00:43 -0500 Mime-Version: 1.0 X-Sender: aspeitia@mail.int.sells.com Message-Id: In-Reply-To: <4899.1091235039@sss.pgh.pa.us> References: <4899.1091235039@sss.pgh.pa.us> Date: Mon, 2 Aug 2004 08:00:44 -0500 To: pgsql-sql@postgresql.org From: Ray Aspeitia Subject: Re: How to create an aggregate? Content-Type: text/plain; charset="us-ascii" ; format="flowed" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/6 X-Sequence-Number: 18503 So the AGGREGATE function also references parameters like a regular SQL function. Good to know. Figured I'd ask anyway. Thanks for the info Tom, Greg. Ray A. > > > I also would like to pass the delimiter to the aggregate as a parameter >> and I am not sure if it can handle that. > >It can't. You'll need a single-argument finalfunc that hardwires the >delimiter, ie, > array_to_string($1, '|') > > regards, tom lane -- Ray Aspeitia Sells Printing Company LLC aspeitia@sells.com (262) 317-8314