Postgres Pro
Downloads
Home   >   mailing lists

using float4, I get incorrect value when select - Mailing list pgsql-general

From Anibal David Acosta F.
Subject using float4, I get incorrect value when select
Date
Msg-id efpukf$8ju$1@sea.gmane.org
Whole thread Raw
Responses Re: using float4, I get incorrect value when select  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Tree view 
Hello, I have a table, with a float4 column, when I insert a new row and for
example I use this value "5000542,5" in the column of type float4, the
insert do OK, but when I select (select myColumn from myTable) I get the
value "5000540" I don't know why.

But if I cast to float8 (select cast(myColumn as float8) from myTable) I get
the correct value ("5000542,5").

I don't know if I am doing something wrong.. Please help me. Thanks

P.D.: I am using postgres 8.1 for windows

Anibal

pgsql-general by date:

Previous
From: "Karl O. Pinc"
Date:
Subject: pg_dump design problem (bug??)
Next
From: "rlee0001"
Date:
Subject: Re: Normal vs Surrogate Primary Keys...