Joshua написа: > I have a column with the following values (example below) > > 5673 > 4731 > 4462 > 5422 > 756 > 3060 > > I want the column to display the numbers as follows: > > 56.73 > 47.31 > 44.62 > 54.22 > 7.56 > 30.60 > > I have been playing around with string functions but cannot seem to > figure out a quick solution. Does anyone have any suggestions?
Use "to_char(int, text)", details here - http://www.postgresql.org/docs/current/static/functions-formatting.html -- Milen A. Radev ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster