float4

From: JT Kirkpatrick <jt-kirkpatrick(at)mpsllc(dot)com>
To: "'pgsql-admin(at)hub(dot)org'" <pgsql-admin(at)hub(dot)org>, "'pgsql-sql(at)hub(dot)org'" <pgsql-sql(at)hub(dot)org>
Subject: float4
Date: 1999-06-28 19:43:37
Message-ID: 01BEC17C.FE853200.jt-kirkpatrick@mpsllc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

we have a database (linux, 6.4.2, new odbc, connections from msaccess /
win98) -- access doesn't fully appreciate the monetary type in postgres, so
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!!!
what are the limitations of float4? should i have used float8?

thanks for any help you can offer. . .

jt

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Don Garrett 1999-06-28 20:30:46 Re: [ADMIN] float4
Previous Message Bruce Momjian 1999-06-28 18:45:57 Re: [SQL] Temporary tables