Re: [GENERAL] JSON objects merge using || operator - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] JSON objects merge using || operator
Date
Msg-id 799.1482343048@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] JSON objects merge using || operator  (Mickaël Le Baillif <mickael.le.baillif@gmail.com>)
List pgsql-general
=?UTF-8?Q?Micka=C3=ABl_Le_Baillif?= <mickael.le.baillif@gmail.com> writes:
> Do you have any reason for giving the same precedence on those operators ?
> A small survey among my colleagues and friends tends to believe that our
> human brain implicitly gives a greater priority to the '->' operator.

PG's operator precedence rules were set long before the JSON types ever
existed.  Even if we wanted to treat -> specially, we couldn't for fear
of breaking existing queries that used custom operators named that.

            regards, tom lane


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] pg_restore to a port where nobody is listening?
Next
From: Tom DalPozzo
Date:
Subject: Re: [GENERAL] error updating a tuple after promoting a standby