| 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: | Whole Thread | Raw Message | 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 |