pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Leslie Mikesell <les@Mcs.Net>
To: daveh@insightdist.com
Cc: les@Mcs.Net
Cc: pgsql-sql@postgreSQL.org
Cc: pgsql-interfaces@postgreSQL.org
Cc: byronn@insightdist.com
Subject: Re: [SQL] excel vs. money data type?
Date: Wed, 26 Aug 1998 10:15:44 -0500 (CDT)
Message-ID: <199808261515.KAA17042@Venus.mcs.net> (raw)
In-Reply-To: <35E40584.3B11394F@insightdist.com>

According to David Hartwig:
> 
> This sounds like a bug I came across a while ago.   Since then, I abandon money in
> favor of float.   I suspect it has to do with the leading "$" and the a conversion
> to a number.   It looks like it has slipped through the proverbial crack.   In any
> case, it will be about a week until this can be addressed.

Thank you.  The weird thing is that the numbers show up in the preview as you
build the query, and access gets the values (but loses the money formatting).  It
is only the 'return to excel' step that loses the numbers.

  Les Mikesell
   les@mcs.com




view thread (3+ messages)

Message-ID: <199808261515.KAA17042@Venus.mcs.net>
Permalink:  ../199808261515.KAA17042@Venus.mcs.net/
Also on:    postgresql.org/message-id/199808261515.KAA17042@Venus.mcs.net

 · 

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: les@Mcs.Net, daveh@insightdist.com, pgsql-sql@postgreSQL.org, byronn@insightdist.com
  Subject: Re: [SQL] excel vs. money data type?
  In-Reply-To: <199808261515.KAA17042@Venus.mcs.net>

* 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