Re: [HACKERS] money data type and conversions]
От | Bruce Momjian |
---|---|
Тема | Re: [HACKERS] money data type and conversions] |
Дата | |
Msg-id | 199906241534.LAA16753@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: [HACKERS] money data type and conversions] (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | 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 по дате отправления: