sql - Postgresql 从包含数组的表中选择与数组中一样多的行

Question

我在使用 Postgesql 的选择请求中遇到问题我有一张 table

+-------------------+-----+
|      array        |value|
+-------------------+-----+
|["1","k"]          |   35|
+-------------------+-----+
|["125","15l","1m"] |   40|
+-------------------+-----+

以及我想要的:

+-------------------+-----+
|      array        |value|
+-------------------+-----+
|   "1"             |   35|
+-------------------+-----+
|   "k"             |   35|
+-------------------+-----+
|   "125"           |   40|
+-------------------+-----+
|   "15l"           |   40|
+-------------------+-----+
|   "1m"            |   40|
+-------------------+-----+

谢谢

Answer 1

你可以使用unnest:

select unnest(array), value
from table_name;

P.S.:我假设 “k” 的值应该是 35。