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.klaver@aklaver.com