From: JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>
To: 'asif@petstore.com' <asif@petstore.com>
Cc: 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org>
Date: Thu, 1 Jul 1999 15:16:18 -0400
Message-ID: <01BEC3D4.AD2F64C0.jt-kirkpatrick@mpsllc.com> (raw)
>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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jt-kirkpatrick@mpsllc.com, asif@petstore.com, pgsql-interfaces@hub.org
Subject: Re:
In-Reply-To: <01BEC3D4.AD2F64C0.jt-kirkpatrick@mpsllc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox