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@xxxxxxxxxxx
