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