Em ter, 24 de set de 2019 às 10:35, PegoraroF10 <
marcos@f10.com.br> escreveu:
>
> If I do ...
> select 1::NUMERIC + 1::BIGINT;
>
> I get ...
> [42725] ERROR: operator is not unique: numeric + bigint Hint: Could not
> choose a best candidate operator. You might need to add explicit type casts.
>
Witch version are you using? I tried it against current master and everything is ok:
fabrizio=# SELECT 1::NUMERIC + 1::BIGINT;
?column?
----------
2
(1 row)
> This error means I have more than one way to calculate that formula ?
> Did I create that operator erroneously ?
>
Did you created an operator for it? Why?
Regards,
--
Fabrízio de Royes Mello Timbira -
http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento