Sim Zacks <sim@compulab.co.il> writes:
>>> I'm not sure offhand what is the easiest way to suppress trailing
>>> zeroes, but casting to plain numeric is not the route to a solution.
> According to the documentation, numeric is stored without any leading
> or trailing zeros.
That says *stored*; it doesn't say *displayed*.
regards, tom lane
