----- "Sim Zacks" <sim@xxxxxxxxxxxxxx> wrote: > >> 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. See below for an explanation of why the above statement is incorrect. http://en.wikipedia.org/wiki/Significant_figures Adrian Klaver aklaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
