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 kleptog@svana.org escribió en el mensaje

[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

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 the