From: | "Mike Ellsworth" <younicycle(at)gmail(dot)com> |
---|---|
To: | fcote(at)fcoinfo(dot)com |
Cc: | "PostgreSQL Novice" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Problem with data storage |
Date: | 2008-04-08 12:03:46 |
Message-ID: | 219951fd0804080503t6be19e2er5f2285111333304a@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Tue, Apr 8, 2008 at 7:37 AM, Francois Cote <francoisco(at)aei(dot)ca> wrote:
> Hi,
>
> One more thing about the money type. At first, I thought that I had
> overflowed the capacity. Sorry for my english here, what I mean is, like a
> signed Byte, the value range from 127 to -128, so what happens when you put
> a value of 136? That's right it become negative. But, reading the
> PostgreSQL documentation, the value of a Money type can range from
> -92233720368547758.08 to +92233720368547758.07. So my 22443018 is way in
> the range to do that behavior, and since I tried adding value using also an
> SQL query, I expected that the PostgreSQL engine could handle the value
> correctly.
>
> I already contacted MicroOLAP for my problems. But for the money type,
> since it doesn't work with an Insert query, I don't expect they can do
> anything.
>
> Thanks for any help you can provide.
Francois,
You may want to search specifically within the hackers list as I
believe there have been 'challenges' for the money type for awhile.
I'm not saying there will be a resolution for your problem - but it
may give you more background on any known issues.
From | Date | Subject | |
---|---|---|---|
Next Message | Raimon Fernandez | 2008-04-09 06:59:48 | warnings restoring a db |
Previous Message | Francois Cote | 2008-04-08 11:37:03 | Re: Problem with data storage |