Sim Zacks <s...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general