[GENERAL] JSON objects merge using || operator

2016-12-19 Thread Mickaël Le Baillif
Hello, I've encountered a disturbing behaviour using the || operator on two jsonb objects extracted from subfields of a common jsonb object. Let's take a look at this example : with data as ( select '{ "nested1": {"lvl1_k1": "v1"}, "nested2": {"lvl2_k1":234, "lvl2_k

Re: [GENERAL] JSON objects merge using || operator

2016-12-21 Thread Mickaël Le Baillif
Le lun. 19 déc. 2016 à 18:52, Tom Lane a écrit : > Since the Postgres parser doesn't have any special knowledge about > the meaning of the -> and || operators, it gives them the same precedence > Thanks for clarifying the situation here. Do you have any reason for giving the same precedence on