Search Postgresql Archives

Re: Operator is not unique

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux