Search Postgresql Archives

Re: Operator is not unique

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux