Re: Operator is not unique

On 9/25/19 6:38 AM, PegoraroF10 wrote:
> Doing a inner join with pg_proc I´ll get this result. So, none of this
> casts I´ve created. Column prorettype is different, this is the problem
> ? select format_type(castsource, NULL), format_type(casttarget, NULL),
> castfunc, castcontext, castmethod, pr.* from pg_cast inner join pg_proc
> pr on castfunc = pr.oid where (castsource = 'numeric'::regtype or
> castsource = 'bigint'::regtype) and format_type(casttarget, NULL) in
> ('numeric','bigint') order by castsource;

Please run the query provided:

select format_type(castsource, NULL), format_type(casttarget, NULL),
castfunc, castcontext, castmethod from pg_cast where castsource =
'numeric'::regtype or castsource = 'bigint'::regtype order by castsource;

> format_type format_type castfunc castcontext castmethod proname
> pronamespace proowner prolang procost prorows provariadic protransform
> prokind prosecdef proleakproof proisstrict proretset provolatile
> proparallel pronargs pronargdefaults prorettype proargtypes
> proallargtypes proargmodes proargnames proargdefaults protrftypes
> prosrc probin proconfig proacl
> bigint numeric 1781 i f numeric 11 10 12 1 0 0 - f false false true
> false i s 1 0 1700 20 NULL NULL NULL NULL NULL int8_numeric NULL NULL NULL
> numeric bigint 1779 a f int8 11 10 12 1 0 0 - f false false
> true false i s 1 0 20 1700 NULL NULL NULL NULL NULL numeric_int8 NULL
> NULL NULL
> numeric numeric 1703 i f numeric 11 10 12 1 0 0 numeric_transform f
> false false true false i s 2 0 1700 1700 23 NULL NULL NULL NULL NULL
> numeric NULL NULL NULL
>
>
> ------------------------------------------------------------------------
> 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