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