Skip site navigation (1) Skip section navigation (2)

Re: Problem with data storage

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: (view raw, whole thread or download thread mbox)
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.

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.

In response to

pgsql-novice by date

Next:From: Raimon FernandezDate: 2008-04-09 06:59:48
Subject: warnings restoring a db
Previous:From: Francois CoteDate: 2008-04-08 11:37:03
Subject: Re: Problem with data storage

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group