pg中多值列_Postgresql 动态统计某一列的某一值出现的次数实例

实例解析：

select to_char(log.date, 'yyyy-MM-dd HH24') as hour,

log.exten, sum(case log.grade when '1' then 1 else 0 end) as "1",

sum(case log.grade when '2' then 1 else 0 end) as "2",

sum(case log.grade when '3' then 1 else 0 end) as "3",

sum(case log.grade when '4' then 1 else 0 end) as "4",

sum(case log.grade when '5' then 1 else 0 end) as "5",

log.direction from iface_satisfaction_investigation as log

where log.date >= '2017-08-03 00:00:00' and log.date < '2017-08-04 00:00:00'

group by hour,log.exten,log.direction order by hour,log.exten,log.direction asc

to_char:用于查询时间格式化，to_char(log.date, 'yyyy-MM-dd HH24')，大致的结果是：2017-08-03 13

sum():毫无疑问是用来计算总和的。

sum(case log.grade when '1' then 1 else 0