Em ter, 24 de set de 2019 às 10:52, PegoraroF10 <mar...@f10.com.br> escreveu: > > I don´t know if I did. >
I think you did. > PostgreSQL 11.5 (Ubuntu 11.5-1.pgdg16.04+1) on x86_64-pc-linux-gnu, compiled > by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.11) 5.4.0 20160609, 64-bit > Take a look: postgres=# SELECT version(); version ---------------------------------------------------------------------------------------------------------------------------------- PostgreSQL 11.5 (Debian 11.5-1.pgdg90+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit (1 row) postgres=# SELECT 1::NUMERIC + 1::BIGINT; ?column? ---------- 2 (1 row) And looking at the catalog: postgres=# SELECT pg_typeof(1::NUMERIC + 1::BIGINT); pg_typeof ----------- numeric (1 row) postgres=# SELECT * FROM pg_operator WHERE oid = '+(numeric, numeric)'::regoperator; oprname | oprnamespace | oprowner | oprkind | oprcanmerge | oprcanhash | oprleft | oprright | oprresult | oprcom | oprnegate | oprcode | oprrest | oprjoin ---------+--------------+----------+---------+-------------+------------+---------+----------+-----------+--------+-----------+-------------+---------+--------- + | 11 | 10 | b | f | f | 1700 | 1700 | 1700 | 1758 | 0 | numeric_add | - | - (1 row) Please, try it in your environment and let us know. Regards, -- Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento