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

help / color / mirror / Atom feed
From: José Soares <jose@sferacarta.com>
To: Herouth Maoz <herouth@oumail.openu.ac.il>
Cc: JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>
Cc: 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org>
Subject: Re: [INTERFACES] RE: [ADMIN] float4
Date: Tue, 29 Jun 1999 12:49:23 +0200
Message-ID: <3778A4B3.20036FEE@sferacarta.com> (raw)
References: <l03130300b39e32c008fd@[147.233.159.109]>

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'





view thread (5+ messages)  latest in thread

Message-ID: <3778A4B3.20036FEE@sferacarta.com>
Permalink:  ../3778A4B3.20036FEE@sferacarta.com/
Also on:    postgresql.org/message-id/3778A4B3.20036FEE@sferacarta.com

 · 

reply
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: jose@sferacarta.com, herouth@oumail.openu.ac.il, jt-kirkpatrick@mpsllc.com, pgsql-interfaces@hub.org
  Subject: Re: [INTERFACES] RE: [ADMIN] float4
  In-Reply-To: <3778A4B3.20036FEE@sferacarta.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