The following bug has been logged on the website:
Bug reference: 14935
Logged by: Jurica Železnjak
Email address: jzelez(at)gmail(dot)com
PostgreSQL version: 10.1
Operating system: OS X
Description:
In some cases when using the shortcut notation "::" the database gives an
error.
GOOD:
CAST("sensors_sensordata"."data" #>> '{Temperature}' AS DOUBLE PRECISION) AS
"temp"
ERROR:
"sensors_sensordata"."data" #>> '{Temperature}'::DOUBLE PRECISION AS
"temp"
ERROR message:
[22P02] ERROR: invalid input syntax for type double precision:
"{Temperature}"