On Tue, Apr 8, 2008 at 7:37 AM, Francois Cote <francoisco@aei.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.