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