Re: BUG #14786: Wrong Precision with money datatype

nithinkrishna(dot)p(at)gmail(dot)com writes:
> I have a table created in postgres database with money datatype. I have
> connected to the database via SQuirrel SQL Client and found that the
> precision of the money datatype is shown as 2147483647. But from the
> postgres documentation the precision and scale should be 19 and 2
> respectively.

You're reading something into the documentation that's not there.
Postgres doesn't have an explicit notion of precision and scale
for type money; those concepts are specific to type numeric.
I think the information_schema views will present made-up, hard-wired
values for the float and integer types as well, but they don't for
money, since its range is locale-dependent.

regards, tom lane