Re: [SQL] Function for adding Money type

From: Thomas Good <tomg(at)sqlclinic(dot)net>
To: <pgsql-hackers(at)postgreSQL(dot)org>
Cc: Postgres SQL List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [SQL] Function for adding Money type
Date: 2003-01-26 13:48:01
Message-ID: Pine.LNX.4.33.0301260846450.2789-100000@q8.nrnet.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

On Sun, 26 Jan 2003, 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.

Hey good news D'Arcy! I prefer using MONEY as well.

-----------------------------------------------------------------------
Thomas Good e-mail: tomg(at)sqlclinic(dot)net
Programmer/Analyst phone: (+1) 718.818.5528
Residential Services fax: (+1) 718.818.5056
Behavioral Health Services, SVCMC-NY mobile: (+1) 917.282.7359

-- Geistiges Eigentum ist Diebstahl! --

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Justin Clift 2003-01-26 13:50:41 Re: Win32 port patches submitted
Previous Message Justin Clift 2003-01-26 13:30:34 Re: Win32 port patches submitted

Browse pgsql-sql by date

  From Date Subject
Next Message D'Arcy J.M. Cain 2003-01-26 13:53:21 Re: [SQL] Function for adding Money type
Previous Message David Durst 2003-01-26 08:49:40 Re: ERROR: Cannot display a value of type RECORD