aggregate functions

Hi there,

is there any easy way to add the string concatenation operator
as a collating operator? I would like to do something like:

id val
------
1  aa
1  bb
2  cc
2  dd
2  ee

select id,join(val,',') from table group by id

id join
-----------
1  aa,bb
2  cc,dd,ee

and it would be nice not having to revert to DBI :-)

Regards,
Mit freundlichem Gruß,
    Holger Klawitter
--
Holger Klawitter                                    +49 (0)251 484 0637
holger@klawitter.de                            http://www.klawitter.de/