Tom Lane wrote:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > Christopher Kings-Lynne wrote:
> >> * Is there any reason there is no RENAME TO command for operators?
> >
> > That might change the precedence of the operator
>
> ... true ...
>
> > and get you in a big mess with stored expressions everywhere.
>
> Not with respect to compiled expressions. It could conceivably break
> stored function source texts and application-generated queries, but
> those are broken a fortiori by the new operator name.
>
> So I don't think this objection has a lot of weight.
IIRC, it was the objection that you put forth when I last attempted to
do it... The question is perhaps not so much whether we can get away
with it, it's whether the behavior is reasonable and consistent for
users that don't know implementation details.