I ended up changing the data types to float8...
Why the warning against using float4?
Will I encounter problems using float8?
-asif.
JT Kirkpatrick wrote:
> >Subject: bug: Access sees money types incorrectly
>
> it's the odbc -- it doesn't recognize the money type. i have had to use
> int4, storing all entries *100 (i.e. 35.99 as 3599), and then on reports be
> sure to divide by 100. DON'T use float4!! in postgres6.5 i understand the
> newer numeric type is available, but i don't know if the odbc can use it
> yet. . .
>
> jt