On Monday 25 June 2007 10:19:49 Fernando Hevia wrote: > > > 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? > > > > Don't use to_char unless you actually want character data though. > > > > Just try this... > > > > SELECT (column/100) FROM table; > > Cast the column in order to get the decimal part: > > SELECT (column::real/100) FROM table; > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend
Good point. Thanks for the catch :) -- ~ manchicken <>< (A)bort, (R)etry, (I)nfluence with large hammer. 09 F9 11 02 9D 74 E3 5B D8 41 56 C5 63 56 88 C0 Please avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/no-word-attachments.html ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
