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]

Reply via email to