Hi guys, I am searching for a function that enables me to strip the trailing zeros in the fractional part of a number (numeric type). For example a number saved in a column of type numeric as such: 23.45000 would be returned as 23.45 I can't find any function that does this in the documentation, does something like this exist or do i need to write some custom function myself? Thanks for any help, Giovanni Martina -- A World of KEIGI http://keigi.blogspot.com ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
