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])
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
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
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
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
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
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