PG中求jsonb中某键对应的值有多少种
假设该字段数据如下:
[{"level_first": "产业外溢"}]
[{"level_first": "产业外溢"}, {"level_first": "企业动态"}]
[{"level_first": "产业外溢"}, {"level_first": "企业动态"}]
[{"level_first": "产业外溢"}, {"level_first": "人事动向"}, {"level_first": "企业动态"}]
[{"level_first": "产业外溢"}]
[{"level_first": "产业外溢"}, {"level_first": "人事动向"}, {"level_first": "企业经营"}, {"level_first": "经营风险"}]
[{"level_first": "产业外溢"}, {"level_first": "人事动向"}]
[{"level_first": "产业外溢"}]
[{"level_first": "产业外溢"}, {"level_first": "企业动态"}, {"level_first": "企业经营"}]
[{"level_first": "产业外溢"}, {"level_first": "人事动向"}]
[{"level_first": "产业外溢"}, {"level_first": "经营状况"}]
[{"level_first": "产业外溢"}, {"level_first": "企业动态"}]
[{"level_first": "产业外溢"}, {"level_first": "人事动向"}, {"level_first": "经营风险"}]
[{"level_first": "产业外溢"}]
则:
SELECT DISTINCT jsonb_array_elements(level_first)->>'level_first'FROM table_name;