Re: Integer divided by integer never produces a real number

On 22 Apr 2020, at 12:04, Groot, Frank (Sociale Verzekeringsbank) wrote:

Hi,

Can you tell me which of the following division outcomes is expected behaviour?

--Division -- outcome select 10/3, -- 3

Hai Frank, This is expected.

10/3.0, -- 3.333 10.0/3, -- 3.333 cast(10 as decimal(18,2))/3, -- 3.333 cast(10 as decimal(18,0))/3, -- 3

Not sure about this. I’ll ask around. Jennie

cast(10 as decimal(18,0))/3.0 -- 3.333 ;

Personally, I would have expected all of the outcomes to be real numbers and not integers. Can you tell me if that is a realistic expectation?

Kind regards,

Frank Groot

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list