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 the
PostgreSQL - general mailing list archive at Nabble.com.