Re: [GENERAL] A real currency type

Pailloncy Jean-Gerard <jg@rilk.com>

From: Pailloncy Jean-Gerard <jg@rilk.com>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2006-03-21T17:15:29Z
Lists: pgsql-hackers
>> This looks very interesting.  Should we add it to the core  
>> distribution?
>
> Excellent question. As yet I have received very little feedback on it,
> though it does work as advertised. I have had some people complain  
> that
> while they'd like to use it (especially the timestamp-that-remembers-
> the-timezone), they don't like the idea of an external module.
>
> I suppose the are a few technical issues that could be raised, like  
> the
> fact that it searches user tables during the parse phase, but this  
> is a
> generic problem with non-immutable type input functions.
>
> I'd like it to be considered for inclusion. If the interest is there I
> can make any changes people suggest.
There was an old thread on the list about "extended type".

The general idea was to add a attribute to each column to represent  
the "unit" (as for physical measure).

I had worked on a development system that use this kind of "extended  
type" and it was very good to catch errors by checking the  
compatibility of extended type.

Cordialement,
Jean-Gérard Pailloncy