Round and trunc dont provide the functionality I need. Say for example I have two values in a column of type numeric as follows: 23.455 12.300 What I need to happen is stripping the "useless" zeros in the fractional part of numbers so 12.300 would become 12.3 and 23.455 would stay the same Round and trunc can´t do this without me first checking if the number can indeed be "rounded" to a number without losing its precise value On 10/3/05, Mike Nolan <nolan@xxxxxxxxxxx> wrote: > Have you looked at the 'round' and 'trunc' functions? > > > 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 > > > > -- A World of KEIGI http://keigi.blogspot.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
