个人使用积累笔记,为了方便自己查找,勿喷。。。
string_to_array
array_length
regexp_split_to_table
regexp_split_to_array
01、生成序列(时间序列或其它序列)
generate_series
select generate_series('2007-02-01'::timestamp ,'2008-04-01'::timestamp, '1 month'::interval) dd;
-- 从函数里的返回值查询时,表别名好像就能当作列名使用
SELECT date_trunc('month', dd)::date FROM generate_series('2007-02-01'::timestamp ,'2008-04-01'::timestamp, '1 month'::interval) dd;
SELECT to_char(date_trunc('month', dd), 'YYYY年MM月') monthstr FROM generate_series('2007-02-01'::timestamp ,'2008-04-01'::timestamp, '1 month'::interval) dd where dd < '2008-04-01'::timestamp