pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

(no subject)
2+ messages / 2 participants
[nested] [flat]

* (no subject)
@ 1999-07-01 19:16  JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>
  0 siblings, 1 reply; 2+ messages in thread

From: JT Kirkpatrick @ 1999-07-01 19:16 UTC (permalink / raw)
  To: 'asif@petstore.com' <asif@petstore.com>; +Cc: 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org>

>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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re:
@ 1999-07-01 21:51  S. Asif Hassan <asif@petstore.com>
  parent: JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>
  0 siblings, 0 replies; 2+ messages in thread

From: S. Asif Hassan @ 1999-07-01 21:51 UTC (permalink / raw)
  To: JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>; +Cc: 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org>


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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~1999-07-01 21:51 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-07-01 19:16  JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>
1999-07-01 21:51 ` Re: S. Asif Hassan <asif@petstore.com>

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