Re: Fixed Point Arithmetic

David Cressey wrote:
"Gene Wirchenko" <genew@xxxxxxxx> wrote in message
news:58rn03pspoga5r87b0v632b4tmug00gq7f@xxxxxxxxxx

"David Cressey" <cressey73@xxxxxxxxxxx> wrote:

[snip]

Are fixed point numbers a useful from for DBMSes to support?

Of course, since they often deal with such numbers. Currency
amounts are almost certainly the most common example.

Thanks. I really liked Oracle's Number (X,2) when I first saw it. And I
don't really care if the arithmetic is a little slow, as long as it's right.

If you're doing some heavy duty arithmetic, like interplanetary trajectory
calculations, don't use the facilities of a DBMS. And learn what you're
doing before doing it.

Why not? It seems to me that the data for a large number of satellites is data one needs to manage, and even our little solar system has thousands of potentially significant satellites.
.