Subject | GROUP_CONCAT function in Firebird? |
---|---|
Author | mailmur |
Post date | 2005-06-09T07:03:02Z |
http://dev.mysql.com/doc/mysql/en/group-by-functions.html
MySQL4.1.x has a nice GROUP_CONCAT aggregate function, which we use a
quite often. Report queries find it usefull.
I still keep a private Firebird installation and try our production
sql queries once in a while, ant not to mention UTF-8 support which
works ok in Mysql but FB has problems.
Is there any workaround to simulate GROUP_CONCAT function in Firebird
engine. Maybe some clever stored procedure or something. Even better
if it worked in any table object, not just with fixed table names+columns.
MySQL4.1.x has a nice GROUP_CONCAT aggregate function, which we use a
quite often. Report queries find it usefull.
I still keep a private Firebird installation and try our production
sql queries once in a while, ant not to mention UTF-8 support which
works ok in Mysql but FB has problems.
Is there any workaround to simulate GROUP_CONCAT function in Firebird
engine. Maybe some clever stored procedure or something. Even better
if it worked in any table object, not just with fixed table names+columns.