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@xxxxxxxxxxxxxxx> 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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
