Re: Integer Question - Does Limit Value Make Sense
От | |
---|---|
Тема | Re: Integer Question - Does Limit Value Make Sense |
Дата | |
Msg-id | 545969.88666.qm@web33314.mail.mud.yahoo.com обсуждение исходный текст |
Ответ на | Re: Integer Question - Does Limit Value Make Sense (Richard Broersma Jr <rabroersma@yahoo.com>) |
Ответы |
Re: Integer Question - Does Limit Value Make Sense
|
Список | pgsql-novice |
> maybe integer(10) is a mysql extension. I think > that postgresql's numeric datatype will do > whatever you want with 10 digits for dollars and two > digits for cents. You can set it to handle > anything that you want as long as you define the > numeric type correctly. > > http://www.postgresql.org/docs/8.2/interactive/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL > > By the way did you make a finial decision one a > table structure for your lending problem? 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. i haven't made a decision yet. i'm thinking through three projects right now and working through the agile webdev book - all on my not so free time. i'll get there, but i need to think it through more so it gels in my head. thanks for the help. ____________________________________________________________________________________ Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail beta. http://new.mail.yahoo.com
В списке pgsql-novice по дате отправления: