Обсуждение: the question about round, truncate

Поиск
Список
Период
Сортировка

the question about round, truncate

От
Hyung Joo Lee
Дата:

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.

Re: the question about round, truncate

От
Ian Lea
Дата:
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.