Em ter, 24 de set de 2019 às 10:52, PegoraroF10 <
marcos@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
