英文:
array_agg function in postgres, when used in java does not return any record/data?
问题
我有一个类似这样的查询：
select sender_id, ARRAY_AGG(receiver_id) as receiver_id from senderTbl group by sender_id
当我在 pgAdmin 中执行这个查询时，它能够正常工作并返回如下记录：
但是，当从Java代码中调用时，它不起作用：
String query = "select sender_id, ARRAY_AGG(receiver_id) as receiver_id from senderTbl group by sender_id";
Query q = session.createSQLQuery(query);
List li = new LinkedList();
li = q.list();
英文:
I have a query like this
select sender_id, ARRAY_AGG(receiver_id) as receiver_id from senderTbl group by sender_id
When I execute this query in pgAdmin it works well and returns the record like this
image
But when called from java code it doesn't work
String query = "select sender_id, ARRAY_AGG(receiver_id) as receiver_id from senderTbl group by sender_id"
Query q = session.createSQLQuery(query);
List li = new LinkedList();
li = q.list();
专注分享java语言的经验与见解，让所有开发者获益！
评论