Re: Money locale currency symbol position - Mailing list pgsql-bugs

From Marko Mikulicic
Subject Re: Money locale currency symbol position
Date
Msg-id 3D456938.606@seul.org
Whole thread Raw
In response to Money locale currency symbol position  (Marko Mikulicic <marko@seul.org>)
List pgsql-bugs
Tom Lane wrote:
> Marko Mikulicic <marko@seul.org> writes:
>
>>   The code in cash.c should be cleaned up completely
>
>
> Such criticism is best expressed in the form of a patch ;-)

No problem, I will send you a patch. However I want to do things
right, because for now my patches for pgsql are ugly hacks that
I keep for myself, mostly for a matter of shame :-)

>
> Note though that most of us think the current money type is a kluge
> anyway; anything based on int4 storage doesn't have enough significant
> digits.  It would be better rewritten as a thin locale-aware veneer
> over type "numeric".
>
>             regards, tom lane

I agree.
Is there an example of  how to inherit from a parametrized type ?
(just redefine input output, reshape the string and pass it to the
"super class")
  Is it possible to redefine only the _in and _out methods of the type
inheriting all other methods.
  How can I creeate a new type using two paramaters (size and precision).
Is possible to view the CREATE TYPE command which creates the
internal type numeric?

If you want to use numeric I guess you cannot use strfmon because it uses
float or double and it's not arbitrary precision.
  Things should be done by hand, like now.

Marko

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug #728: Interactions between bytea and character encoding when doing analyze
Next
From: Tom Lane
Date:
Subject: Re: [PORTS] make check fails -- 8 hour time difference in old dates