Re: BUG #13506: jsonb || operator does not work

On Mon, Jul 20, 2015 at 7:44 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> gregoire(dot)hubert(at)pragmafabrik(dot)com writes:
>> select val->'a'||val->'c' from (values ($j${"a": {"b": 2}, "c": {"d":
>> 3}}$j$::jsonb)) a (val);
>
> You're making unwarranted assumptions about the precedence of those
> operators.
>
> (val->'a')||(val->'c') does what you expect. Working out what the
> expression does as-written is left as an exercise for the reader.

Ok, I got it: select (val->'a')||(val->'c') from…

Thank you for taking the time to reply.

Regards,
--
Grégoire HUBERT
Tel: 06.60.15.49.80
PragmaFabrik
http://www.pragmafabrik.com