Postgres Pro
Downloads
Home   >   mailing lists

BUG #14935: Cast function shortcut gives an error - Mailing list pgsql-bugs

From jzelez@gmail.com
Subject BUG #14935: Cast function shortcut gives an error
Date
Msg-id 20171129082705.1464.33608@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #14935: Cast function shortcut gives an error  (Marko Tiikkaja <marko@joh.to>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      14935
Logged by:          Jurica Železnjak
Email address:      jzelez@gmail.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}"

pgsql-bugs by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: [BUGS] Improper const-evaluation of HAVING with grouping sets and subquery pullup
Next
From: Marko Tiikkaja
Date:
Subject: Re: BUG #14935: Cast function shortcut gives an error