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