Re: [BUGS] float conversion / presentation problem ?

2005-04-06 Thread Neil Conway
Enrico Weigelt wrote: BTW: real is an alias to float4 ? Yes. -Neil ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [BUGS] float conversion / presentation problem ?

2005-04-06 Thread Tom Lane
John R Pierce <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> You do realize that float4/real is only good to six decimal places >> on most platforms? > and importantly, are stored as binary fractions. 0.1 decimal is a > repeating fraction in binary, its like .1100110011 x 2^-2 or > some

Re: [BUGS] float conversion / presentation problem ?

2005-04-06 Thread John R Pierce
Tom Lane wrote: Enrico Weigelt <[EMAIL PROTECTED]> writes: i've noticed an problem with conversion from real to float - this produces ugly values. (in fact it seems to be real->float8) You do realize that float4/real is only good to six decimal places on most platforms? You can take the issue up

Re: [BUGS] float conversion / presentation problem ?

2005-04-06 Thread Tom Lane
Enrico Weigelt <[EMAIL PROTECTED]> writes: > i've noticed an problem with conversion from real to float - > this produces ugly values. (in fact it seems to be real->float8) You do realize that float4/real is only good to six decimal places on most platforms? You can take the issue up with the gl

[BUGS] float conversion / presentation problem ?

2005-04-06 Thread Enrico Weigelt
Hi folks, i've noticed an problem with conversion from real to float - this produces ugly values. (in fact it seems to be real->float8) > fxignal=# SELECT 12.345::real::float; > float8 > -- > 12.3450002670288 Maybe its not really an conversion problem, but an bug in sp

[BUGS] BUG #1585: could not read from statistics collector pipe

2005-04-06 Thread Jean-Pierre Pelletier
The following bug has been logged online: Bug reference: 1585 Logged by: Jean-Pierre Pelletier Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Windows 2000 Server, Service Pack 4 Description:could not read from statistics collector pipe De

[BUGS] 8.0.1 Installation Error in Windows XP

2005-04-06 Thread Mehul Doshi-A20614
Title: Message Hi,   While installing on one of the systems out here having Windows XP, I ran into this error:   Service "PostgreSQL Database Server 8.0' (pgsql-8.0) could not be installed. Verify that you have sufficient privileges to install system services. Retry - Cance