From: Oliver Elphick <olly@lfix.co.uk>
To: pgsql-hackers@postgreSQL.org
Cc: josh@agliodbs.com
Cc: ddurst@larubber.com
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Function for adding Money type
Date: 26 Jan 2003 16:03:00 +0000
Message-ID: <1043596980.29189.10.camel@linda.lfix.co.uk> (raw)
In-Reply-To: <200301260853.21987.darcy@druid.net>
References: <34741.10.1.86.1.1043451677.squirrel@www.la-rubber.com>
<200301241617.09544.josh@agliodbs.com>
<200301260853.21987.darcy@druid.net>
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.Elphick@lfix.co.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: olly@lfix.co.uk, pgsql-hackers@postgreSQL.org, josh@agliodbs.com, ddurst@larubber.com
Subject: Re: [SQL] Function for adding Money type
In-Reply-To: <1043596980.29189.10.camel@linda.lfix.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox