Re: BigDecimal

Glenn Holmer <gholmer(at)weycogroup(dot)com> writes:
> We're starting a Java project for our retail stores using Postgres,
> and would like to store BigDecimal values for price, payment, etc.
> because the data will be exported to an IBM iSeries server ("AS/400").
> What is the correct Postgres data type to use?

I'd say decimal a/k/a numeric.

> I would assume
> "decimal"; when the docs say "User-specified precision" with a range
> of "~8000 digits" does that mean the decimal point can fall anywhere
> within those 8000 digits?

Where did you find this remark about "8000 digits"? The actual
limitation imposed by the source code seems to be 1000 digits, although
I'm darned if I can see why it's not closer to 8000 ...

regards, tom lane