01.11.2012 17:02, Kjell Rilbe wrote: > If it's not too complicated to describe (it's just out of curiosity...), > then please what is the "proper solution"?
The obvious one (though not necessarily meaning the only one) is to have even longer numerics and use them in cases when an int64 based intermediate result is likely to overflow. Of course, it's not about native CPU numerics but some more complex implementation (BCD based or alike), so those computations are expected to be much slower. From the complexity POV it's about introducing a brand new data type (even if it's not surfaced in SQL). I'm working in this direction. Dmitry ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
