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(dot)klaver(at)aklaver(dot)com