Thread
-
Warning!!
Marc G. Fournier <scrappy@hub.org> — 1998-11-03T21:29:10Z
Tomorrow afternoon, at ~5pm ADT, I will be tag'ng and releasing v6.4 to the world *muhahahaha* Any last minute "no, don't do it" naysayers out there? :) Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org -
Re: [HACKERS] Warning!!
D'Arcy J.M. Cain <darcy@druid.net> — 1998-11-03T21:49:07Z
Thus spake The Hermit Hacker > Tomorrow afternoon, at ~5pm ADT, I will be tag'ng and releasing v6.4 to > the world *muhahahaha* > > Any last minute "no, don't do it" naysayers out there? :) I have this idea for a new feature... -- D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 424 2871 (DoD#0082) (eNTP) | what's for dinner. -
Re: [HACKERS] Warning!!
Marc G. Fournier <scrappy@hub.org> — 1998-11-03T22:37:50Z
On Tue, 3 Nov 1998, D'Arcy J.M. Cain wrote: > Thus spake The Hermit Hacker > > Tomorrow afternoon, at ~5pm ADT, I will be tag'ng and releasing v6.4 to > > the world *muhahahaha* > > > > Any last minute "no, don't do it" naysayers out there? :) > > I have this idea for a new feature... Shhhh...bruce might hear you *rofl* Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org -
Re: [HACKERS] Warning!!
Bruce Momjian <maillist@candle.pha.pa.us> — 1998-11-04T02:40:02Z
> On Tue, 3 Nov 1998, D'Arcy J.M. Cain wrote: > > > Thus spake The Hermit Hacker > > > Tomorrow afternoon, at ~5pm ADT, I will be tag'ng and releasing v6.4 to > > > the world *muhahahaha* > > > > > > Any last minute "no, don't do it" naysayers out there? :) > > > > I have this idea for a new feature... > > Shhhh...bruce might hear you *rofl* New feature! Tell me more... -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
-
Re: [HACKERS] Warning!!
A James Lewis <james@vrtx.net> — 1998-11-04T03:07:50Z
I'm very new to this list, and I have to first say that 6.4beta5 fixes every problem I had encountered with 6.3.2 (A small list..) A bug I didn't encounter isn't a bug for me... BUT... Just now I saw and posted this... testdb=> select cash_mul_flt8('$1', '123.74'); cash_mul_flt8 ------------- $123.73 (1 row) If the pence is 0-4 it rounds down... surely that's a rounding bug because it should be looking at the next significant figure? It's really small, and insignificant but I guess I should tell somone... On Tue, 3 Nov 1998, Bruce Momjian wrote: > > On Tue, 3 Nov 1998, D'Arcy J.M. Cain wrote: > > > > > Thus spake The Hermit Hacker > > > > Tomorrow afternoon, at ~5pm ADT, I will be tag'ng and releasing v6.4 to > > > > the world *muhahahaha* > > > > > > > > Any last minute "no, don't do it" naysayers out there? :) > > > > > > I have this idea for a new feature... > > > > Shhhh...bruce might hear you *rofl* > > New feature! Tell me more... > > -- > Bruce Momjian | http://www.op.net/~candle > maillist@candle.pha.pa.us | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 > James (james@linuxrocks.co.uk) Vortex Internet My Windows unders~1 long filena~1, and yours? -
Re: [HACKERS] Warning!!
Thomas Lockhart <lockhart@alumni.caltech.edu> — 1998-11-04T07:34:52Z
> > > Any last minute "no, don't do it" naysayers out there? :) > > I have this idea for a new feature... *grin* Thanks D'Arcy. Glad to see we didn't pound your sense of humor out of ya. Will try harder next time ;) I've been able to reproduce Jose's report of problems when casting floats to text. The problem is that there is no explicit float to text conversion function, but for other reasons I had decided to make float and datetime equivalent (to allow weird date arithmetic). When Postgres starts fishing around for conversion functions, it matches them up: tgl=> select text(f) from a where f = 1; text ---------------------------- Sat Jan 01 00:00:01 2000 GMT (1 row) Yuck. Anyway, I don't think it is a show stopper, and can be fixed with a patch and in the v6.4.1 release. Probably should not make datetime and float binary equivalent types as they are now. - Tom -
Re: [HACKERS] Warning!!
Thomas Lockhart <lockhart@alumni.caltech.edu> — 1998-11-04T07:45:41Z
> I'm very new to this list, and I have to first say that 6.4beta5 fixes > every problem I had encountered with 6.3.2 (A small list..) > Just now I saw and posted this... > If the pence is 0-4 it rounds down... surely that's a rounding bug > because it should be looking at the next significant figure? tgl=> select cash_mul_flt8('$123.77', '1'); cash_mul_flt8 ------------- $123.77 (1 row) tgl=> select cash_mul_flt8('$1', '123.77'); cash_mul_flt8 ------------- $123.76 (1 row) That's annoying; it's non-symmetric too. The money type is stored as an integer, and the float type is an IEEE double; looks like we have an LSB rounding problem. Not sure what to do about it other than remove the function, which isn't desirable I'm sure... - Tom -
Re: [HACKERS] Warning!!
A James Lewis <james@vrtx.net> — 1998-11-04T13:37:10Z
Don't remove it... After all, I'm using this workaround in my software for now and it seems OK.... testdb=> select cash_mul_flt8('$1', '123.77'); cash_mul_flt8 ------------- $123.76 (1 row) testdb=> select cash_mul_flt8('$1', '123.77000001'); cash_mul_flt8 ------------- $123.77 (1 row) It happens in float4 too.... On Wed, 4 Nov 1998, Thomas G. Lockhart wrote: > > I'm very new to this list, and I have to first say that 6.4beta5 fixes > > every problem I had encountered with 6.3.2 (A small list..) > > Just now I saw and posted this... > > If the pence is 0-4 it rounds down... surely that's a rounding bug > > because it should be looking at the next significant figure? > > tgl=> select cash_mul_flt8('$123.77', '1'); > cash_mul_flt8 > ------------- > $123.77 > (1 row) > > tgl=> select cash_mul_flt8('$1', '123.77'); > cash_mul_flt8 > ------------- > $123.76 > (1 row) > > That's annoying; it's non-symmetric too. The money type is stored as an > integer, and the float type is an IEEE double; looks like we have an LSB > rounding problem. Not sure what to do about it other than remove the > function, which isn't desirable I'm sure... > > - Tom > James (james@linuxrocks.co.uk) Vortex Internet My Windows unders~1 long filena~1, and yours? -
Re: [HACKERS] Warning!!
Bruce Momjian <maillist@candle.pha.pa.us> — 1998-11-04T13:57:57Z
> > > I'm very new to this list, and I have to first say that 6.4beta5 fixes > every problem I had encountered with 6.3.2 (A small list..) A bug I didn't > encounter isn't a bug for me... > > BUT... > > Just now I saw and posted this... > > testdb=> select cash_mul_flt8('$1', '123.74'); > cash_mul_flt8 > ------------- > $123.73 > (1 row) > > If the pence is 0-4 it rounds down... surely that's a rounding bug because > it should be looking at the next significant figure? > > It's really small, and insignificant but I guess I should tell somone... > Works here on BSD/OS 4.0. Looks like an OS bug, perhaps. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 -
Re: [HACKERS] Warning!!
Bruce Momjian <maillist@candle.pha.pa.us> — 1998-11-04T14:02:54Z
> > I'm very new to this list, and I have to first say that 6.4beta5 fixes > > every problem I had encountered with 6.3.2 (A small list..) > > Just now I saw and posted this... > > If the pence is 0-4 it rounds down... surely that's a rounding bug > > because it should be looking at the next significant figure? > > tgl=> select cash_mul_flt8('$123.77', '1'); > cash_mul_flt8 > ------------- > $123.77 > (1 row) > > tgl=> select cash_mul_flt8('$1', '123.77'); > cash_mul_flt8 > ------------- > $123.76 > (1 row) > > That's annoying; it's non-symmetric too. The money type is stored as an > integer, and the float type is an IEEE double; looks like we have an LSB > rounding problem. Not sure what to do about it other than remove the > function, which isn't desirable I'm sure... This is really bad. I can't imagine a 5-digit double is loosing rounding on a double. There must be some other problem, but I can't reproduce it here on BSD/OS. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 -
Re: [HACKERS] Warning!!
A James Lewis <james@vrtx.net> — 1998-11-04T14:57:52Z
It only happens here for some figues, not all.... mostly xx.x[1234] On Wed, 4 Nov 1998, Bruce Momjian wrote: > > > I'm very new to this list, and I have to first say that 6.4beta5 fixes > > > every problem I had encountered with 6.3.2 (A small list..) > > > Just now I saw and posted this... > > > If the pence is 0-4 it rounds down... surely that's a rounding bug > > > because it should be looking at the next significant figure? > > > > tgl=> select cash_mul_flt8('$123.77', '1'); > > cash_mul_flt8 > > ------------- > > $123.77 > > (1 row) > > > > tgl=> select cash_mul_flt8('$1', '123.77'); > > cash_mul_flt8 > > ------------- > > $123.76 > > (1 row) > > > > That's annoying; it's non-symmetric too. The money type is stored as an > > integer, and the float type is an IEEE double; looks like we have an LSB > > rounding problem. Not sure what to do about it other than remove the > > function, which isn't desirable I'm sure... > > This is really bad. I can't imagine a 5-digit double is loosing > rounding on a double. There must be some other problem, but I can't > reproduce it here on BSD/OS. > > -- > Bruce Momjian | http://www.op.net/~candle > maillist@candle.pha.pa.us | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 > James (james@linuxrocks.co.uk) Vortex Internet My Windows unders~1 long filena~1, and yours? -
Re: [HACKERS] Warning!!
A James Lewis <james@vrtx.net> — 1998-11-04T15:04:02Z
I hope it is! I dont have the skill set to track it down but mabe a library? On Wed, 4 Nov 1998, Bruce Momjian wrote: > > > > > > I'm very new to this list, and I have to first say that 6.4beta5 fixes > > every problem I had encountered with 6.3.2 (A small list..) A bug I didn't > > encounter isn't a bug for me... > > > > BUT... > > > > Just now I saw and posted this... > > > > testdb=> select cash_mul_flt8('$1', '123.74'); > > cash_mul_flt8 > > ------------- > > $123.73 > > (1 row) > > > > If the pence is 0-4 it rounds down... surely that's a rounding bug because > > it should be looking at the next significant figure? > > > > It's really small, and insignificant but I guess I should tell somone... > > > > Works here on BSD/OS 4.0. Looks like an OS bug, perhaps. > > -- > Bruce Momjian | http://www.op.net/~candle > maillist@candle.pha.pa.us | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 > James (james@linuxrocks.co.uk) Vortex Internet My Windows unders~1 long filena~1, and yours? -
Re: [HACKERS] Warning!!
Thomas Lockhart <lockhart@alumni.caltech.edu> — 1998-11-04T15:19:03Z
> It only happens here for some figures, not all.... mostly xx.x[1234] What system and compiler are you using? - Tom -
Re: [HACKERS] Warning!!
Bruce Momjian <maillist@candle.pha.pa.us> — 1998-11-04T16:15:15Z
> On Wed, 4 Nov 1998, Bruce Momjian wrote: > > > > > I'm very new to this list, and I have to first say that 6.4beta5 fixes > > > > every problem I had encountered with 6.3.2 (A small list..) > > > > Just now I saw and posted this... > > > > If the pence is 0-4 it rounds down... surely that's a rounding bug > > > > because it should be looking at the next significant figure? > > > > > > tgl=> select cash_mul_flt8('$123.77', '1'); > > > cash_mul_flt8 > > > ------------- > > > $123.77 > > > (1 row) > > It only happens here for some figues, not all.... mostly xx.x[1234] I used your exact example, and it worked here. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 -
Re: [HACKERS] Warning!!
A James Lewis <james@vrtx.net> — 1998-11-04T17:03:57Z
Sorry, should have been the first thing to say... Linux 2.0.29 GCC 2.7.2 /lib/libc.so.5.3.12 For some reason it won't compile on my newer system GCC 2.8.1/glibc but I'll look at that when I have some time.... On Wed, 4 Nov 1998, Thomas G. Lockhart wrote: > > It only happens here for some figures, not all.... mostly xx.x[1234] > > What system and compiler are you using? > > - Tom > James (james@linuxrocks.co.uk) Vortex Internet My Windows unders~1 long filena~1, and yours?
-
Re: [HACKERS] Warning!!
Thomas Lockhart <lockhart@alumni.caltech.edu> — 1998-11-04T17:37:34Z
> Linux 2.0.29 > GCC 2.7.2 > /lib/libc.so.5.3.12 Similar to mine (Linux-2.0.30, gcc-2.7.2.1, same libc), which also showed the symptom. I've also tried compiling in the past with egcs-1.1 and found many more floating point rounding differences. So it's a gcc/libc problem. In it's defense, I'm more accustomed to seeing more odd rounding behavior with other platforms. btw, this is definitely *not* an issue to affect our upcoming release. - Tom -
Re: [HACKERS] Warning!!
Bruce Stephens <bruce@cenderis.demon.co.uk> — 1998-11-04T22:54:43Z
A James Lewis <james@vrtx.net> writes: > Sorry, should have been the first thing to say... > > Linux 2.0.29 > GCC 2.7.2 > /lib/libc.so.5.3.12 > > For some reason it won't compile on my newer system GCC 2.8.1/glibc but > I'll look at that when I have some time.... I just tried the same example on 6.4beta4, with linux2.0.36pre something, glibc and egcs1.1. (It compiled fine, for what it's worth.) I also get this erroneous behaviour: postgres=> select cash_mul_flt8('$1', '123.77'); cash_mul_flt8 ------------- $123.76 (1 row) and postgres=> select cash_mul_flt8('$1', '123.99'); cash_mul_flt8 ------------- $123.98 (1 row) This may be sense from a numerical analysis point of view, but it suggests there's a problem somewhere: this is surely behaving in a surprising way.