From: | Ian Lea <ian(dot)lea(at)gmail(dot)com> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: the question about round, truncate |
Date: | 2010-02-05 09:41:11 |
Message-ID: | 8c4e68611002050141n36de6791tbddbbdcccb2be941@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)imrc(dot)kist(dot)re(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Ibrahim Harrani | 2010-02-05 09:43:53 | vacuum deadlock |
Previous Message | Hyung Joo Lee | 2010-02-05 07:35:01 | the question about round, truncate |