Re: Operator is not unique

On 9/24/19 7:18 AM, PegoraroF10 wrote:
> Nope, seems I didn´t create anything.
> 
> SELECT * FROM pg_operator WHERE oid = '+(numeric, bigint)'::regoperator;
> ERROR: operator does not exist: +(numeric, bigint)
> 
> Ok, I can cast, it works. But why works without casting for you and not for
> me ?

Per Tom's suggestion try:

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;

> 
> 
> 
> --
> Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com