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
[EMAIL PROTECTED]
(262) 317-8314
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]