Re: [HACKERS] money data type and conversions] - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] money data type and conversions]
Date
Msg-id 199906241534.LAA16753@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] money data type and conversions]  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Bruce Momjian <maillist@candle.pha.pa.us> writes:
> > Maybe we will have to add '$' symbols to a special case of the numeric
> > type, or add a function to output numeric in money format?
> 
> I like the last idea (add a formatting function), because it's simple,
> self-contained, and doesn't force any solutions on anyone.  Don't want
> any decoration on your number?  Just read it out.  Don't like the
> decoration added by the formatting function?  Write your own function.
> No table reconstruction required.  With a data-type-driven approach,
> changing your mind is painful because you have to rebuild your tables.
> 
> We'd probably also want an inverse function that would strip off the
> decoration and produce a numeric, but that's easy too...

Added to TODO:
* Remove Money type, add money formatting for decimal type               
I should add I have reorganized the TODO list to be clearer.  People may
want to check it out on our newly designed web site.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Kristofer Munn
Date:
Subject: Re: [HACKERS] Perl 5 Interface on 6.5 and lo_creat/lo_open problem
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] The dangers of "-F"