From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] money data type and conversions] |
Date: | 1999-06-24 15:34:53 |
Message-ID: | 199906241534.LAA16753@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-06-24 15:42:36 | Re: [HACKERS] The dangers of "-F" |
Previous Message | Kristofer Munn | 1999-06-24 15:28:14 | Re: [HACKERS] Perl 5 Interface on 6.5 and lo_creat/lo_open problem |