您可以将这些值连接在一起,然后再将其输入到array_agg()
函数中:
SELECT user_id, array_agg('[' || friend_id || ',' || confirmed || ']') as friends
FROM friends_map
WHERE user_id = 1
GROUP BY user_id
演示:SQL Fiddle
Postgres-将两列汇总为一项
您可以将这些值连接在一起,然后再将其输入到array_agg()
函数中:
SELECT user_id, array_agg('[' || friend_id || ',' || confirmed || ']') as friends
FROM friends_map
WHERE user_id = 1
GROUP BY user_id
演示:SQL Fiddle