From: | mark(at)mark(dot)mielke(dot)cc |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Stephen Frost <sfrost(at)snowman(dot)net>, "Brian C(dot) DeRocher" <brian(dot)derocher(at)mitretek(dot)org>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [BUGS] numerics lose scale and precision in views of unions |
Date: | 2006-08-10 14:17:39 |
Message-ID: | 20060810141738.GA15704@mark.mielke.cc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
On Thu, Aug 10, 2006 at 09:20:09AM -0400, mark(at)mark(dot)mielke(dot)cc wrote:
> Mathematically, 1.0 = 0.9500... -> 1.05000...
>
> In theory, B-Tree could be fine with this. As long as the operators
> for =, <>, <, and > are made to consistently understand this principle.
> For example:
>
> 1.0 = 0.95
> 1.0 = 1.05
> 1.0 <> 0.94
> 1.0 <> 1.06
> 0.94 < 1.0
> 1.06 > 1.0
>
> I'm not sure that it warrants being changed, though. Storing mixed
> precision values in a column and expecting the database to understand
> rounding rules does not appeal to me. Too magical.
I take this back. It's magical enough to be impossible.
If 1.0 is inserted, and then 1.05, it could consider them 'equal' and
put them together. If 1.1 and 1.14 were inserted, they could be 'equal'
and put together. Then an insertion of '1' would have to re-group them
all together, making the B-Tree ineffective.
So - taking back what I say above.
Cheers,
mark
--
mark(at)mielke(dot)cc / markm(at)ncf(dot)ca / markm(at)nortel(dot)com __________________________
. . _ ._ . . .__ . . ._. .__ . . . .__ | Neighbourhood Coder
|\/| |_| |_| |/ |_ |\/| | |_ | |/ |_ |
| | | | | \ | \ |__ . | | .|. |__ |__ | \ |__ | Ottawa, Ontario, Canada
One ring to rule them all, one ring to find them, one ring to bring them all
and in the darkness bind them...
From | Date | Subject | |
---|---|---|---|
Next Message | dror | 2006-08-10 15:51:35 | Re: BUG #2558: initDB failed to run |
Previous Message | Tom Lane | 2006-08-10 13:38:10 | Re: [BUGS] numerics lose scale and precision in views of unions |
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2006-08-10 14:49:41 | Re: 8.2 features status |
Previous Message | Tom Lane | 2006-08-10 14:14:03 | Re: Casts |