Re: Operator is not unique - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Operator is not unique
Date
Msg-id f3480478-6387-f5aa-6998-e6bf737af280@aklaver.com
Whole thread Raw
In response to Re: Operator is not unique  (PegoraroF10 <marcos@f10.com.br>)
Responses Re: Operator is not unique
List pgsql-general
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



pgsql-general by date:

Previous
From: Marco Ippolito
Date:
Subject: "Failed to connect to Postgres database"
Next
From: Adrian Klaver
Date:
Subject: Re: could not accept SSL connection: sslv3 alert bad certificate