Re: BUG #14935: Cast function shortcut gives an error

Ok. Thanks... I guess I should bring attention to this to the Django team where they use it without the parenthesis. Jurica > On Wednesday, Nov 29, 2017 at 10:52 AM, Marko Tiikkaja wrote: > On Wed, Nov 29, 2017 at 10:27 AM, wrote: > > 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" > > The precedence between the two is different. The equivalent would be: > > ("sensors_sensordata"."data" #>> '{Temperature}')::DOUBLE PRECISION > > In other words, not a bug. > > > .m