PLSQL 季度函数写法/for循环动态sql执行

参考文章：

1. 从PostgreSQL函数返回SETOF行

2. PL/pgSQL 的循环语句

3. PostgreSQL 遍历表的PLSQL列举

 

目标是实现季度函数的统计，可以使用的sql

SELECT COUNT(gd_zmj),TO_CHAR(qd_rq,'YYYY-Q') FROM td_ht_xz GROUP BY TO_CHAR(qd_rq,'YYYY-Q')
SELECT COUNT(gd_zmj),TO_CHAR(qd_rq,'YYYY年Q季') FROM td_ht_xz GROUP BY TO_CHAR(qd_rq,'YYYY年Q季')

SELECT COUNT(gd_zmj), TO_CHAR(qd_rq, 'YYYY-q')
FROM td_ht_xz
WHERE TO_CHAR(qd_rq, 'YYYY-q') >= '2018-1'
  and TO_CHAR(qd_rq, 'YYYY-q') <= '2018-2'
GROUP BY TO_CHAR(qd_rq, 'YYYY-q')

-- 2018-01季度写法