原创置顶 贱一白 最后发布于2015-03-19 15:15:11 阅读数 6665 收藏
展开
实例表:
postgres=# \d book
Table "public.book"
Column | Type | Modifiers
--------+-------------------+---------------------------------------------------
id | integer | not null default nextval('book_id_seq'::regclass)
name | character varying |
tag | character varying |
postgres=# select * from book;
id | name | tag
----+------+----------
1 | java | aa,bb,cc
2 | C++ | dd,ee
(2 rows)
需要的效果:
name | unnest
------+--------
java | aa
java | bb
java | cc
C++ | dd
C++ | ee
(5 rows)
方法1: unnest(数组,分隔符)
postgres=# select name,unnest(st