PostgreSQL SELECT 的高级用法(CTE, LATERAL, ORDINALITY, WINDOW, SKIP LOCKED,...
标签
PostgreSQL , CTE , LATERAL , ORDINALITY , WINDOW , SKIP LOCKED , DISTINCT , GROUPING SETS , distinct on
背景
1、WITH ORDINALITY,输出函数返回记录的每行行号
《PostgreSQL 9.4 Add SQL Standard WITH ORDINALITY support for UNNEST (and any other SRF)》
2、LATERAL,独立子查询内支持JOIN子查询外面的表
《PostgreSQL 9.3 add LATERAL support》
3、GROUPING SETS, CUBE and ROLLUP。多维聚合