Re: Integer Question - Does Limit Value Make Sense - Mailing list pgsql-novice

From
Subject Re: Integer Question - Does Limit Value Make Sense
Date
Msg-id 255979.4072.qm@web33308.mail.mud.yahoo.com
Whole thread Raw
In response to Re: Integer Question - Does Limit Value Make Sense  (Richard Broersma Jr <rabroersma@yahoo.com>)
List 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 by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: Integer Question - Does Limit Value Make Sense
Next
From:
Date:
Subject: Re: Data (Table) Structure Question