>> 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.