From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Oliver Elphick <olly@lfix.co.uk>
Cc: 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: Mon, 27 Jan 2003 15:14:57 -0500 (EST)
Message-ID: <200301272014.h0RKEvH27942@candle.pha.pa.us> (raw)
In-Reply-To: <1043596980.29189.10.camel@linda.lfix.co.uk>
Oliver Elphick wrote:
> 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.
Agreed. We can default to locale but need a way of overriding that,
ideally with atttypmod at the column level. I assume this will be done
for 7.4 (you said "this year")?
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
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: pgman@candle.pha.pa.us, 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: <200301272014.h0RKEvH27942@candle.pha.pa.us>
* 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