Glenn Holmer <gholmer@weycogroup.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