converting rows into a string
SELECT array_to_string(array(
SELECT cn_name FROM t_city
),'/')
"北京/上海/重庆"
converting rows into a string
SELECT array_to_string(array(
SELECT cn_name FROM t_city
),'/')
"北京/上海/重庆"
转载于:https://my.oschina.net/chenlei65368/blog/119257