>> According to the documentation, numeric is stored without any leading >> or trailing zeros. >> > > That says *stored*; it doesn't say *displayed*. > > regards, tom lane > If it displays them, it has to know they exist. That means it stores it somewhere. > The part of the above that you need to look at is where it says it does not > store 'any extra leading or trailing zeroes'. In your case you entered the > value with three trailing zeroes which are taken to be significant (see Toms > reply also). If you had inserted just 15 you would have gotten back 15. > I guess that's a matter of interpretation. To me zeros after a decimal point without anything else after them are extra.
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
