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 wrote:
> Dear all.
>
>
>
> I have a question about
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))
