From: | PegoraroF10 <marcos(at)f10(dot)com(dot)br> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Operator is not unique |
Date: | 2019-09-25 13:38:50 |
Message-ID: | 1569418730413-0.post@n3.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2019-09-25 14:20:41 | Re: managing primary key conflicts while restoring data to table with existing data |
Previous Message | Krishnakant Mane | 2019-09-25 11:46:56 | Re: managing primary key conflicts while restoring data to table with existing data |