Re: [GENERAL] A real currency type - Mailing list pgsql-hackers

From Pailloncy Jean-Gerard
Subject Re: [GENERAL] A real currency type
Date
Msg-id CB1782A5-DA89-4176-B3C6-697A4185C64E@rilk.com
Whole thread Raw
In response to Re: [GENERAL] A real currency type  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: [GENERAL] A real currency type
List 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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problems with CREATE AGGREGATE and user defined state type.
Next
From: Josh Berkus
Date:
Subject: Re: [GENERAL] A real currency type