-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Chris,
I finally managed to check the Postgresql manual. You're correct; numeric (not numeric(8.2) ) is indeed the more suitable data type for currency values. Thanks and best regards, Bernd On Fri, 22 Jul 2011 19:19:03 -0700 Chris Travers <[email protected]> wrote: > test=> select > '1.23534534653574552345324634522576527664746523452435253452345234'::float; > float8 > ------------------ > 1.23534534653575 > (1 row) > > test=> select > '1.23534534653574552345324634522576527664746523452435253452345234'::numeric; > numeric > ------------------------------------------------------------------ > 1.23534534653574552345324634522576527664746523452435253452345234 > (1 row) > > > The documentation says there is no limit to the size of a numeric > value but I am skeptical. > > test=> select > '1235345346535745523453246345225765276647465234524352.53452345234'::numeric; > numeric > ------------------------------------------------------------------ > 1235345346535745523453246345225765276647465234524352.53452345234 > (1 row) > > It is probably good enough though. > Best Wishes, > Chris Travers > _______________________________________________ > SQL-Ledger mailing list > [email protected] > http://lists.ledger123.com/mailman/listinfo/sql-ledger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iEYEARECAAYFAk4uriAACgkQpYU8M8PbPV5JJgCfTuTz5ftizAPkws/Q/+jaudTa UfAAn1mi3ZoRjoCJNQSfNlisQXpne39K =DEMi -----END PGP SIGNATURE----- _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
