Re: Integer Question - Does Limit Value Make Sense

Поиск
Список
Период
Сортировка
От
Тема Re: Integer Question - Does Limit Value Make Sense
Дата
Msg-id 255979.4072.qm@web33308.mail.mud.yahoo.com
обсуждение исходный текст
Ответ на Re: Integer Question - Does Limit Value Make Sense  (Richard Broersma Jr <rabroersma@yahoo.com>)
Список pgsql-novice
--- Richard Broersma Jr <rabroersma@yahoo.com> wrote:

> > Richard, i got it to work, but i'm now banging my
> head
> > on an extension that stores pennies and converts
> to
> > dollar and cents.  anyway, i'll figure it out
> > eventually.
>
> Do you have some sort of extention that you are
> trying to figure out the use of, or are you
> looking for an algorithm that will convert units in
> pennies to decimal dollars?
>
> Regards,
>
> Richard Broersma Jr.
>

Richard, dollars_and_cents is a RoR extension that
allows one to store everything in the db as cents
(integer) and then automatically convert back to
dollars in the application itself.

the column name has to be [name]_in_cents.  i chose
price_in_cents.  the extension automatically makes
[name] available to the app, in my case price, and
formats it in monetary notation.

all i needed to do was restart my server to get it to
take effect.  i finally have it running right now.



____________________________________________________________________________________
Cheap talk?
Check out Yahoo! Messenger's low PC-to-Phone call rates.
http://voice.yahoo.com

В списке pgsql-novice по дате отправления:

Предыдущее
От: Richard Broersma Jr
Дата:
Сообщение: Re: Integer Question - Does Limit Value Make Sense
Следующее
От:
Дата:
Сообщение: Re: Data (Table) Structure Question