From: | <operationsengineer1(at)yahoo(dot)com> |
---|---|
To: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Integer Question - Does Limit Value Make Sense |
Date: | 2006-11-26 00:47:44 |
Message-ID: | 545969.88666.qm@web33314.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | operationsengineer1 | 2006-11-26 00:48:25 | Re: Integer Question - Does Limit Value Make Sense |
Previous Message | Andrej Ricnik-Bay | 2006-11-25 23:00:50 | Re: Inserting values into a variable table |