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;
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: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
