[MonetDB-users] basic math error?

Kirk Abbott kabbott at daxpy.com
Tue Sep 23 22:27:24 CEST 2008


Hello All,
sql>select 585.0 / 635.0;
+----------------------+
| sql_div_single_value |
+======================+
| 0                    |
+----------------------+

and

sql>select cast(585.0 / 635.0 as  numeric(10,4));
+----------------------+
| sql_div_single_value |
+======================+
| 0.0000               |
+----------------------+

Is not what I was expecting.

Ideas?
Kirk.





More information about the users-list mailing list