What would be the easiest way to get back only the meaningful digits of a numeric value in a pgsql function? eg?
1.002 --> 1.002 1.020 --> 1.02 1.200 --> 1.2 1.000 --> 1 Thanks SWK ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster