>
> For those still following this thread, and looking for more examples
> of the infinite representations of numbers ;-), here is another...
>
> Instead of a binary fixed point, you can use a binary number with an
> implicit decimal fixed point. For example, if your implicit decimal
> point were
Thursday, September 29, 2005, 10:12:44 PM, Dennis Cote wrote:
> On 9/29/05, Darren Duncan <[EMAIL PROTECTED]> wrote:
>[...]
>>> 2. DECIMAL(p,s) - An exactly remembered fractional number that is
>> typically stored in a form akin to text, such as one byte per base-10
>> digit. These can
On 9/29/05, Darren Duncan <[EMAIL PROTECTED]> wrote:
>
> At 11:07 AM -0600 9/29/05, Dennis Cote wrote:
> >As you can see, the result of exact (integer) division is also exact
> >(integer) with implementation defined precision and scale. The
> >result of an expression containing approximate
On 9/29/05, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
>
> True mathematically but not in practice. All fractional numbers are
> represented as floating point, therefore there are no exact fractional
> numbers on any SQL implementations I am aware of. It's possible
> to do, but I've never seen it
At 11:07 AM -0600 9/29/05, Dennis Cote wrote:
As you can see, the result of exact (integer) division is also exact
(integer) with implementation defined precision and scale. The
result of an expression containing approximate (floating point)
values is approximate (floating point). So SQLite
5 matches
Mail list logo
