Re: json ->> operator precedence

On Wed, Aug 5, 2015 at 8:42 AM, Geoff Winkless <pgsqladmin(at)geoff(dot)dj> wrote:

> On 5 August 2015 at 14:35, John McKown <john(dot)archie(dot)mckown(at)gmail(dot)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.
>

​Ah. I see your point now. Sorry about that.​

>
> Geoff​
>
>

--

Schrodinger's backup: The condition of any backup is unknown until a
restore is attempted.

Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.

He's about as useful as a wax frying pan.

10 to the 12th power microphones = 1 Megaphone

Maranatha! <><
John McKown