MySQL和PostgreSQL group by后 Concatenate 拼接所有的字符串
MySQL:
GROUP_CONCAT(DISTINCT t2.T_CODES ORDER BY t2.T_CODES ASC) AS t_str,
PostgreSQL 8.4
array_to_string(array_agg(t2.T_CODES), ', ') AS t_str,
PostgreSQL 9 +
string_agg(t2.T_CODES), ', ')
MySQL:
GROUP_CONCAT(DISTINCT t2.T_CODES ORDER BY t2.T_CODES ASC) AS t_str,
PostgreSQL 8.4
array_to_string(array_agg(t2.T_CODES), ', ') AS t_str,
PostgreSQL 9 +
string_agg(t2.T_CODES), ', ')