From: | José Soares <jose(at)sferacarta(dot)com> |
---|---|
To: | Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il> |
Cc: | JT Kirkpatrick <jt-kirkpatrick(at)mpsllc(dot)com>, "'pgsql-interfaces(at)hub(dot)org'" <pgsql-interfaces(at)hub(dot)org> |
Subject: | Re: [INTERFACES] RE: [ADMIN] float4 |
Date: | 1999-06-29 10:49:23 |
Message-ID: | 3778A4B3.20036FEE@sferacarta.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Herouth Maoz ha scritto:
> At 23:53 +0300 on 28/06/1999, JT Kirkpatrick wrote:
>
> > ouch. hard to think of dollars only when you are paying vendors,
> > technicians, billing customers, etc. surely i won't have to make an int
> > field for the dollars and an int field for the cents!!! the money field
> > would work nicely if the odbc driver would handle it correctly!
> >
> > i forwarded this to the odbc list -- any idea why a money field can't be
> > used from msaccess97 through the odbc??
>
> Perhaps as a work around you should use an integer field, which is scaled
> two places to the left? That is, if you have 300.52 dollars, you keep the
> number 30052 in the field. Surely you can play around with the forms you
> use, so that the real field will be hidden, and get its value from a
> visible field multiplied by 100.
>
> It becomes a problem if your sums can go beyond the 2^31 limit. But if you
> have 6.4, you may use int8 and double your upper limit.
>
> The problem with the money type is that queries on it return it with a
> currency mark, which I'm sure is bad for odbc.
>
> Herouth
>
> --
> Herouth Maoz, Internet developer.
> Open University of Israel - Telem project
> http://telem.openu.ac.il/~herutma
I would like to reccomend to use the DECIMAL type instead of MONEY but I see
that PSQLODBC doesn't recognize
yet this type, maybe we can ask Byron to add this new feature to PSQLODBC ?
--
______________________________________________________________
PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jose'
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Ridenour | 1999-06-29 12:00:52 | Re: [INTERFACES] ODBC and Access 2000: linked tables problem |
Previous Message | Moray McConnachie | 1999-06-29 10:43:30 | ODBC and Access 2000: linked tables problem |