postgresql查询集合结果用逗号分隔返回字符串处理的操作
项目招商找A5 快速获取精准代理名单
这篇文章主要介绍了postgresql 查询集合结果用逗号分隔返回字符串处理的操作，具有很好的参考价值，希望对大家有所帮助。一起跟随小编过来看看吧。
关键字：
1string_agg('' , '')
例如：
1select string_agg(name||'' , ',') from sys_user
补充：PostgreSQL 字段用逗号 “，”隔开 判断是否含有某个值
Array Functions and Operators
https://www.postgresql.org/docs/9.2/functions-array.html
-- ------------------------------ Table structure for T_STUDENT-- ----------------------------DROP TABLE IF EXISTS "public"."T_STUDENT";CREATE TABLE "public"."T_STUDENT" ("id" int4,"name" varchar(255) COLLATE "default","course" varchar(255) COLLATE "default")WITH (OIDS=FALSE);-- ------------------------------ Records of T_STUDENT-- ----------------------------INSERT INTO "public"."T_STUDENT" VALUES ('1', '李四', '12,45,1,66,7,89');INSERT INTO "public"."T_STUDENT" VALUES ('2', '刘一', '1,5,8,9');INSERT INTO "public"."T_STUDENT" VALUES ('3', '王五', '0,4,2');INSERT INTO "public"."T_STUDENT" VALUES ('4', '张三', '1,2,5,7');-- ------------------------------ Alter Sequences Owned By -- ------------------------------ ------------------------------ Table structure for T_STUDENT-- ----------------------------DROP TABLE IF EXISTS "public"."T_STUDENT";CREATE TABLE "public"."T_STUDENT" ("id" int4,"name" varchar(255) COLLATE "default","course" varchar(255) COLLATE "default")WITH (OIDS=FALSE);-- ------------------------------ Records of T_STUDENT-- ----------------------------INSERT INTO "public"."T_STUDENT" VALUES ('1', '李四', '12,45,1,66,7,89');INSERT INTO "public"."T_STUDENT" VALUES ('2', '刘一', '1,5,8,9');INSERT INTO "public"."T_STUDENT" VALUES ('3', '王五', '0,4,2');INSERT INTO "public"."T_STUDENT" VALUES ('4', '张三', '1,2,5,7');-- ------------------------------ Alter Sequences Owned By -- ----------------------------id name course4张三1,2,5,71李四12,45,1,5,66,7,892刘一1,5,8,93王五0,4,2SELECT * FROM "public"."T_STUDENT" WHERE string_to_array(course, ',') @> ARRAY['2','7']结果：id name course4张三1,2,5,7SELECT * FROM "public"."T_STUDENT" WHERE string_to_array(course, ',') <@ array['5','12','45','1','0','4','2']结果：id name course3王五0,4,2SELECT * FROM "public"."T_STUDENT" WHERE string_to_array(course, ',') && ARRAY['5','8','225','111']结果：id name course4张三1,2,5,72刘一1,5,8,9
文章来源：脚本之家
来源地址：https://www.jb51.net/article/205152.htm
尊敬的看官您对postgresql查询集合结果用逗号分隔返回字符串处理的操作有什么看法呢？互联网品牌制作专家愿与您共同探讨！版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容， 请加微信号oem365 举报，一经查实，本站将立刻删除。上一篇: postgresql实现字符串分割字段转列表查询 返 回 下一篇:postgresql将逗号分隔的字符串转为多行的实例
