Re: [SQL] Function for adding Money type

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@sqlclinic.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!              --