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(at)sells(dot)com
(262) 317-8314