Обсуждение: the question about round, truncate
Dear all.
I have a question about round, truncate.
I want to fix the data like 3-digit decimal after being rounded on 4-digit decimal.
Ex. Geometryformat(‘linestring((54.11238742 22.023498293, 35.128937123 94.129837123))’,-1);
-------> #######(‘linestring((54.112 22.023, 35.129 94.130))’,-1);
What should I do?
I want to use the round, truncate command.
I’m sorry my English is poor.
Best regards and thanks in advance.
Kevin.
test=> select round(54.11238742, 3); round -------- 54.112 is maybe what you want. P.S. pgsql-admin list is for postgresql admin questions. http://www.postgresql.org/community/lists/ -- Ian. On Fri, Feb 5, 2010 at 7:35 AM, Hyung Joo Lee <procarrie@imrc.kist.re.kr> wrote: > Dear all. > > > > I have a question about round, truncate. > > > > I want to fix the data like 3-digit decimal after being rounded on 4-digit > decimal. > > > > Ex. Geometryformat(‘linestring((54.11238742 22.023498293, 35.128937123 > 94.129837123))’,-1); > > -------> #######(‘linestring((54.112 22.023, 35.129 94.130))’,-1); > > > > What should I do? > > > > I want to use the round, truncate command. > > > > I’m sorry my English is poor. > > > > > > Best regards and thanks in advance. > > > > Kevin.