由于版本太低,无法使用string_agg,array_agg等系统函数,
能用postgreSQL自定义函数实现吗,求可执行代码!!!
--建表--
create table test
(
dept varchar(10)
,ename varchar(10)
);
--插数--
insert into test values ('技术部','小刘');
insert into test values ('技术部','小黄');
insert into test values ('技术部','小曾');
insert into test values ('销售部','小秦');
insert into test values ('销售部','小邓');
insert into test values ('宣传部','老大');
insert into test values ('宣传部','老二');
insert into test values ('宣传部','老三');
select * from test
dept ename
"技术部"; "小刘"
"技术部"; "小黄"
"技术部"; "小曾"
"销售部"; "小秦"
"销售部"; "小邓"
"宣传部"; "老大"
"宣传部"; "老二"
"宣传部"; "老三"
如何实现????
dept sum_ename
"宣传部"; "老二,老三,老大"
"技术部";" 小刘,小黄,小曾"