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