7;Tom Lane'; '[EMAIL PROTECTED]'
Subject:Re: [ADMIN] RE: [SQL] float4
> ahh, so 6.5 has an answer! for our "cash and accounts payable" database
i
> converted the float4 field to int4, and altered the input mask on the
front
> end to show a decimal point, but not
> ahh, so 6.5 has an answer! for our "cash and accounts payable" database i
> converted the float4 field to int4, and altered the input mask on the front
> end to show a decimal point, but not save it with the data. so now i am
> saving $35.99 as 3599. i had to alter all reports to divide by
ahh, so 6.5 has an answer! for our "cash and accounts payable" database i
converted the float4 field to int4, and altered the input mask on the front
end to show a decimal point, but not save it with the data. so now i am
saving $35.99 as 3599. i had to alter all reports to divide by 100. w
JT Kirkpatrick <[EMAIL PROTECTED]> writes:
> we made all monetary fields FLOAT4's. weird stuff -- or maybe not to you
> -- we insert 23516.69 into a float4 field directly in psql, and then select
> it, and it shows 23516.7. this is not good for a field used for MONEY!!!
Yup, no surprise. fl
