[MonetDB-users] sql - division
Hello, How do I modify this sql to get correct answer? sql> select 10/100; I got 0 instead of 0.10 Thanks. Dariusz.
On Fri, Feb 13, 2009 at 12:07:41PM -0500, dariuszs wrote:
Hello, How do I modify this sql to get correct answer? sql> select 10/100; I got 0 instead of 0.10
select 10.0/100 should help. We will look at set of type related problems after the comming release. Niels
Thanks. Dariusz.
------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
Hi, That doesn't help. The code below seems to work. Thanks. Dariusz sql> select cast(10 as float) / 100; Niels Nes wrote:
On Fri, Feb 13, 2009 at 12:07:41PM -0500, dariuszs wrote:
Hello, How do I modify this sql to get correct answer? sql> select 10/100; I got 0 instead of 0.10
select 10.0/100 should help. We will look at set of type related problems after the comming release.
Niels
Thanks. Dariusz.
------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
dariuszs
-
Niels Nes