Re: json ->> operator precedence
| От | John McKown |
|---|---|
| Тема | Re: json ->> operator precedence |
| Дата | |
| Msg-id | CAAJSdjh=++4HbhaWcYPjkVYGEV-jZ5RbRiaad+o4zNAYZjxTnw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: json ->> operator precedence (Geoff Winkless <pgsqladmin@geoff.dj>) |
| Список | 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.
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
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
В списке pgsql-general по дате отправления: