Hi all. I have silly question. Look at "numeric" type. According to docs it must be "up to 131072 digits before the decimal point; up to 16383 digits after the decimal point". Well, lets see. => select 1::numeric/3; ?column? ------------------------ 0.33333333333333333333 Well, I expect 16383 digits after ".". But nope. => select (1::numeric/3-0.33333333333333333333)*1e20; ?column? ------------------------ 0.00000000000000000000 => select (1::numeric/3-0.33333333333333333332)*1e20; ?column? ------------------------ 1.00000000000000000000 There is only 20 "3" after ".". Well, may be this is not a problem, but why are they infinite number of "0" after the point? I can write even => select (1::numeric/3-0.33333333333333333333)*1e100000; ?column? ------------------------ 0.00000000000000000000 Result the same. According to the docs: "Numeric values are physically stored without any extra leading or trailing zeroes." -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
