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(at)klawitter(dot)de http://www.klawitter.de/