postgres=> SELECT SUM(n::numeric) FROM (VALUES(1),(2.01),(3)) v(n);
ERROR: integer: unhandled type: decimal.Decimal (errno 1105) (sqlstate HY000)
postgres=> SELECT SUM(n::numeric) FROM (VALUES(1.01),(2),(3)) v(n);
ERROR: interface conversion: interface {} is int32, not decimal.Decimal
postgres=> postgres=# SELECT SUM(n::numeric) FROM (VALUES(1),(2.01),(3)) v(n);
sum
------
6.01
(1 row)
postgres=# SELECT SUM(n::numeric) FROM (VALUES(1.01),(2),(3)) v(n);
sum
------
6.01
(1 row)