> 06.03.2012 20:54, Adriano dos Santos Fernandes wrote:
> > It will be 0.333... (up to the maximum NUMBER scale precision).
> >
> > The thing is that for operations like addition, subtraction, NUMBER
> > will work like NUMERIC (i.e., it's results are more precise than DOUBLE).
>
> In this case much easier is to change intermediate result of division to
> floating-point type. No need to introduce new type for this.
Division is not the only difference with math between Dialect 1 and 3
Dialect 1
select 2/3 from rdb$database => 0.667
select 2 * 1.00000000001 from rdb$database => 2.000
Dialect 3
select 2/3 from rdb$database => 0
select 2 * 1.00000000001 from rdb$database => 2. 00000000002
Sean
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
