[MonetDB-users] basic math error?

Romulo Goncalves R.A.Goncalves at cwi.nl
Wed Sep 24 00:37:54 CEST 2008


I think this example gives you the answer:
 >select 4/5;
&1 0 1 1 1
% . # table_name
% sql_div_single_value # name
% tinyint # type
% 1 # length
[ 0     ]
 >select 4%5;
&1 0 1 1 1
% . # table_name
% mod_single_value # name
% tinyint # type
% 1 # length
[ 4     ]
 >

/ divide
% modulo

Romulo

Kirk Abbott wrote:
> 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.
> 
> 
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users





More information about the users-list mailing list