Re: json ->> operator precedence - Mailing list pgsql-general

From Geoff Winkless
Subject Re: json ->> operator precedence
Date
Msg-id CAEzk6ffm0=P2ezuX2TyOx0SWBF2rE_TcWiaN+-sXh3t11v-V4g@mail.gmail.com
Whole thread Raw
In response to Re: json ->> operator precedence  (John McKown <john.archie.mckown@gmail.com>)
Responses Re: json ->> operator precedence
List pgsql-general
On 5 August 2015 at 14:35, John McKown <john.archie.mckown@gmail.com> wrote:
​Looks correct to me. As I understand it the ::jsonb is NOT an operator! It is a syntactic construct for a CAST(). An equivalent which might make more sense is:

​My issue is nothing to do with the ::jsonb cast, it's the precedence of the ->> operator​.

​As far as I can see the ->> operator has predence below '- +' but above 'IS', but there's no entry for it in that place in the precedence table.

Geoff​

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: idle processes
Next
From: John McKown
Date:
Subject: Re: json ->> operator precedence