正常select * from table，数据结构如图：
image.png
现需要将第一行的四个数量转为列，即原有3条数据变为12条数据。
image.png
语法应用：unnest
Select id,
title,
unnest(array ['1_num', '2_num', '3_count', '4_num']) as point,
unnest(array [1_num, 2_num, 3_count, 4_num]) as point_num,
to_char(publish_time, 'HH24:MI') publish_time
from table
