Sim Zacks <sim@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
