From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
---|---|
To: | pgsql-hackers(at)postgreSQL(dot)org |
Cc: | josh(at)agliodbs(dot)com, ddurst(at)larubber(dot)com, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: [SQL] Function for adding Money type |
Date: | 2003-01-26 16:03:00 |
Message-ID: | 1043596980.29189.10.camel@linda.lfix.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
On Sun, 2003-01-26 at 13:53, D'Arcy J.M. Cain wrote:
> This year, my team is planning on improving the MONEY type. Of course, we can
> always make it a user defined type if PostgreSQL doesn't want it. We will at
> least put it into contrib. However, if people think that it is useful and
> want to leave it in the main tree that's good too. What we want to do is a)
> switch to a 64 bit integer from a 32 bit integer in order to hold amounts of
> any reasonabe size and b) allow it to be cast to and from more types.
> Perhaps we can also add the ability to specify the number of decimal places
> on output but I am not sure if that would affect the primary benefit of using
> it, speed.
A money type needs to specify what currency is held. The current one
changes the currency with the locale, which makes nonsense of existing
data.
--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Wash me thoroughly from mine iniquity, and cleanse me
from my sin. For I acknowledge my transgressions; and
my sin is ever before me. Against thee, thee only,
have I sinned, and done this evil in thy sight..."
Psalms 51:2-4
From | Date | Subject | |
---|---|---|---|
Next Message | Ross J. Reedstrom | 2003-01-26 16:17:43 | Re: Can we revisit the thought of PostgreSQL 7.2.4? |
Previous Message | Greg Copeland | 2003-01-26 15:39:33 | postgresql.org |
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew Nuzum | 2003-01-26 19:52:08 | Re: Scheduling Events? |
Previous Message | D'Arcy J.M. Cain | 2003-01-26 13:53:21 | Re: [SQL] Function for adding Money type |