Re: [HACKERS] money data type and conversions]

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

In response to

Browse pgsql-hackers by date

  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