the question about round, truncate

From: Hyung Joo Lee <procarrie(at)imrc(dot)kist(dot)re(dot)kr>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: the question about round, truncate
Date: 2010-02-05 07:35:01
Message-ID: 3E94D039A2B82544B3E7D48F924B0B255D0F7EB13C@base.imrc.kist.re.kr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ian Lea 2010-02-05 09:41:11 Re: the question about round, truncate
Previous Message Achilleas Mantzios 2010-02-04 09:00:39 Re: Issues with LC_COLLATE, across 8.3/8.4 on various platforms