Re: Problem with data storage

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.