Re: How to create an aggregate?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ray Aspeitia <aspeitia(at)sells(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to create an aggregate?
Date: 2004-07-31 00:50:39
Message-ID: 4899.1091235039@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Ray Aspeitia <aspeitia(at)sells(dot)com> writes:
> 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Patrice OLIVER 2004-08-01 16:07:34 Need help form inherits
Previous Message Ray Aspeitia 2004-07-30 18:46:36 How to create an aggregate?