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