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
