ERROR: type “double” does not exist
实验环境
操作系统:CentOS Linux release 7.3.1611 (Core)
数据库系统: PostgreSQL 9.6.5
问题重现
编写了一个求平均值的聚合函数查询,强制将平均值转化为double类型时报错:
xinku=# SELECT id,avg(priority)::double
xinku-# FROM crms_crime.b_apply_info
xinku-# group by id
xinku-# ;
ERROR: type "double" does not exist
第1行SELECT id,avg(priority)::double