On Wed, Aug 5, 2015 at 8:42 AM, Geoff Winkless <pgsqlad...@geoff.dj> wrote:
> On 5 August 2015 at 14:35, John McKown <john.archie.mck...@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. > 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