Use the numeric data type. You must have Postgres 6.5 or greater.
Michael J Davis
BackOffice Development, TV Guide Networks
Office: 303-267-6809 Fax: 303-267-6889
Home Office: 303-460-7360 Fax: 303-460-7362
Pager: 303-461-4002
Email: Michael.J.Davis@tvguide.com
> -----Original Message-----
> From: Didier Gasser-Morlay [SMTP:didierg@visualgroup.com]
> Sent: Thursday, January 06, 2000 2:40 AM
> To: pgsql-interfaces@postgreSQL.org
> Subject: [INTERFACES] ODBC oin Windows
>
> I have downloaded and happilly installed the odbc driver for Windows
> from insightdist.com
>
> I am using Delphi 4 SP3 on Windows NT 4 SP3 and I have the following
> questions/problems
>
> 1. Money type is seen has a float. Delphi complains when trying to post
> a float into a money
> 2. Int8 is seen as a 17 byte string
> 3. float4 is seens as using 8 bytes (as float8)
>
> 4. Since the money type is not recommended, I was planning to store
> money amount in int8 forcing the number of decimals to a known number.
> Since delphi sees int8 as a string this makes life a bit tricky,
> especially doing calculations. How do you store large money amounts (4
> bytes when you store e.g. italian Lira or Spanish Pesetas is a bit
> small)
>
> Any ideas ?
>
> Didier
>
>
>
>
> --
> --------------------------------------------------------------------------
> ------------------
> Any views or opinions are solely those of the author and do not
> necessarily
> represent those of Visual Communications Group or its principal
> operating
> divisions (FPG, Telegraph Colour Library, Planet Earth Pictures,
> Colorific!, Pix, Giraudon, Bavaria Bildagentur).
> --------------------------------------------------------------------------
> ------------------
> The information transmitted is intended only for the person or entity to
> which
> it is addressed, and may contain confidential and/or privileged
> material.
> If you are not the intended recipient of this message, please do not
> read,
> copy, use or disclose this communication; and please notify the sender
> immediately. It should be noted that any review, retransmission,
> dissemination or other use of, or taking action in reliance upon, this
> information by persons or entities other than the intended recipient is
> prohibited.
> --------------------------------------------------------------------------
> ------------------
>
> ************