PostgreSQL 高级特性. FILTER RETURNING 特性

1.统计数量

FilterWhere方法:SELECTCOUNT(*)FILTER(WHERELEVEL='VIP')ASvip_count,COUNT(*)FILTER(WHERELEVEL='SVIP')ASvip_countFROMend_customer

2.返回自增ID

INSERTINTOend_customer(LEVEL)VALUES('VIP')RETURNINGID

3.Level分组获取最新数据

SELECTDISTINCTON(LEVEL)idas最新ID,LEVELFROMend_customerORDERBYLEVEL,idDESC

总结

记录一下.