--- Alejandro <amosteo@...> a écrit : > Hi!

>
> I'm trying to do some floating point operations in a
> select, but
> there aren't table columns involved (at least not
> for certain
> results).
>
> Say, for example that I have:
>
> select 7.0 / 800.0, x.Other_Data
> from A_Table x;
>
> My first column is returning 0, because only two
> decimals are being
> used and result is below that. I've checked it with
> larger values and
> in fact the maximum precision I get is 0.01
>
> Is there some parameter or configuration option
> which allows for
> increased precision?
>
> Thanks in advance!
>
>

When i execute your example, I get 0.00875 as result.
Perhaps you need to use CAST(column as Decimal(8,3))









Vous manquez d’espace pour stocker vos mails ?
Yahoo! Mail vous offre GRATUITEMENT 100 Mo !
Créez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/

Le nouveau Yahoo! Messenger est arrivé ! Découvrez toutes les nouveautés pour dialoguer instantanément avec vos amis. A télécharger gratuitement sur http://fr.messenger.yahoo.com