Re: [GENERAL] using float4, I get incorrect value when select

2006-10-04 Thread Anibal David Acosta F.
I am newbie in postgres. But I think that the value is stored correctly because when select and cast the column to float8 the postgres return the correct value and when I insert, no overflow or other error occur. Thanks Martijn "Martijn van Oosterhout" escribió en el mensaje news:[EMAIL PROT

Re: [GENERAL] using float4, I get incorrect value when select

2006-10-02 Thread Martijn van Oosterhout
On Sun, Oct 01, 2006 at 10:47:27PM -0400, Anibal David Acosta F. wrote: > 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 th

[GENERAL] using float4, I get incorrect value when select

2006-10-02 Thread Anibal David Acosta F.
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(myC