Re: Operator is not unique

On 9/25/19 1:14 PM, PegoraroF10 wrote:
> format_type format_type castfunc castcontext castmethod
> bigint smallint 714 a f
> bigint integer 480 a f
> bigint real 652 i f
> bigint double precision 482 i f
> bigint numeric 1781 i f
> bigint regclass 1287 i f
> bigint regtype 1287 i f
> bigint regconfig 1287 i f
> bigint regdictionary 1287 i f
> bigint regrole 1287 i f
> bigint regnamespace 1287 i f
> bigint bit 2075 e f
> bigint money 3812 a f
> bigint oid 1287 i f
> bigint regproc 1287 i f
> bigint regprocedure 1287 i f
> bigint regoper 1287 i f
> bigint regoperator 1287 i f
> numeric bigint 1779 a f
> numeric smallint 1783 a f
> numeric integer 1744 a f
> numeric real 1745 i f
> numeric double precision 1746 i f
> numeric money 3824 a f
> numeric numeric 1703 i f
>

Hmm, nothing strange here AFAICT.

What does:

select oprname, oprkind, oprleft, oprright, oprresult, oprcode from
pg_operator where oprname = '+';

show?

Have you made any changes/additions to CASTs and/or OPERATORs recently?

>
> ------------------------------------------------------------------------
> Sent from the PostgreSQL - general mailing list archive
> <https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html> at
> Nabble.com.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com