nithinkrishna.p@gmail.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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs