Re: [GENERAL] A real currency type

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Pailloncy Jean-Gerard <jg(at)rilk(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] A real currency type
Date: 2006-03-21 18:03:02
Message-ID: 20060321180302.GI15742@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Tue, Mar 21, 2006 at 06:15:29PM +0100, Pailloncy Jean-Gerard wrote:
> >>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.

While I'm not sure it makes sense to include such an 'extended type' in
the base system, it would be a neat project to have on pgFoundry.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2006-03-21 18:05:54 Re: [GENERAL] A real currency type
Previous Message Tom Lane 2006-03-21 17:54:12 Re: Troubling On-line Backup LOG messages

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2006-03-21 18:05:54 Re: [GENERAL] A real currency type
Previous Message Josh Berkus 2006-03-21 17:39:09 Re: [GENERAL] A real currency type