From: Ian Lea <ian.lea@gmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: the question about round, truncate
Date: Fri, 5 Feb 2010 09:41:11 +0000
Message-ID: <8c4e68611002050141n36de6791tbddbbdcccb2be941@mail.gmail.com> (raw)
In-Reply-To: <3E94D039A2B82544B3E7D48F924B0B255D0F7EB13C@base.imrc.kist.re.kr>
References: <3E94D039A2B82544B3E7D48F924B0B255D0F7EB13C@base.imrc.kist.re.kr>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ian.lea@gmail.com
Subject: Re: the question about round, truncate
In-Reply-To: <8c4e68611002050141n36de6791tbddbbdcccb2be941@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox