SS> OK, can you make example how engine (with you extension) will handle this:
SS> select 1.000000000 / 1.0000000000 from rdb$database SS> select 0.000000001 / 9.0000000000 from rdb$database SS> select 1.000000001 / 0.0000000001 from rdb$database There is no such thing like "my extension". I point out a problem to see what people think and to see suggestions about how to solve it. I didn't propose a complete solution, nor a way to implement it, just throw some ideas in the air, in the hope that discussion will lead to a good solution. The link sent by Geoff can be a good starting point for implementation. SS> I don't understand your situation from practical point of view. SS> If you can accept losses during computing, why can't you accept DOUBLE SS> PRECISION? Because I need accuracy in the stored data, something that double precision doesn't guarantee. Fields are declared as numeric/decimal, and I don't think casting all the formulas is an elegant solution. I also cannot agree that FB just refuses to do a calculation because the sum of the member's scales is higher than 18. If the result of the calculation is being stored in a numeric/decimal field/variable, it already tells how many digits the user really cares about in the result. []s Carlos http://www.firebirdnews.org FireBase - http://www.FireBase.com.br ------------------------------------------------------------------------------ Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users amazing mobile app experiences with Intel(R) XDK. Use one codebase in this all-in-one HTML5 development environment. Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs. http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
