Skip site navigation (1) Skip section navigation (2)

Re: Integer Question - Does Limit Value Make Sense

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: (view raw, whole thread or download thread mbox)
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.
> 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

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.

In response to


pgsql-novice by date

Next:From: operationsengineer1Date: 2006-11-26 00:48:25
Subject: Re: Integer Question - Does Limit Value Make Sense
Previous:From: Andrej Ricnik-BayDate: 2006-11-25 23:00:50
Subject: Re: Inserting values into a variable table

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group