Re: How useful is the money datatype?

Bruce Momjian wrote:
> Guy Rouillier wrote:
>> Christophe Pettus wrote:
>>> On Oct 4, 2009, at 7:09 PM, Guy Rouillier wrote:
>>>> There is no reason why PG could not support packed decimal.
>>> Is that not NUMERIC?
>> No, that is not NUMERIC.  All numeric types are stored as binary
>> representations.  Packed decimal is not.  Perhaps an example would
>> clarify.  The number 1234 would be represented as follows:
>
> I think you are wrong.  The Postgres documentation say:

You are correct, I am wrong, as private emails also pointed out.  I
should read more carefully.  This list is rapidly self-correcting ;).
Thanks.

The IBM implementation provided language libraries (usually COBOL) that
also supported packed decimal, so precision was maintained throughout
the entire application stack.

--
Guy Rouillier