Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id A89C4632899 for ; Fri, 5 Feb 2010 05:41:52 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 20010-04 for ; Fri, 5 Feb 2010 09:41:37 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f228.google.com (mail-bw0-f228.google.com [209.85.218.228]) by mail.postgresql.org (Postfix) with ESMTP id EB36A6324A4 for ; Fri, 5 Feb 2010 05:41:32 -0400 (AST) Received: by bwz28 with SMTP id 28so1736654bwz.34 for ; Fri, 05 Feb 2010 01:41:31 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :from:date:message-id:subject:to:content-type :content-transfer-encoding; bh=MATbw5H3K7YYP8nCTeCqfeLLlsDsEcTdBMScRFTOM+Y=; b=B+dhdOq6oDsGxtu/+WiVtSy/438oKkuCqNWhTb65SgKuUB5TGxjgJ2vn4PZVwo0Id1 aPkSWy6P/vtvemTnhoR/2dCrGM9c5S5h4lm58vuS6BcQox/Za+yHkywYjCKXDgniaWGw MIcFVrsj6HBu39ItlSt/0cRdGOIaC1BPVZyD0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type:content-transfer-encoding; b=cOiN8pW7v0gwYJa9eRa7g6rpRTBkYNFuNdUsHFZxPsq5aQGVa3Zi+Yemce2qK+3vYp e4XrC/YbWgwGqOLBXKHpNlSrKYbPHT9Udi+mPgufL06UblfhUpzF/7yAAho+0hyM8XSU 5nYaVvxUiylJLofJd8D6Fm/sKL3rbVA+iqd1Y= MIME-Version: 1.0 Received: by 10.204.156.27 with SMTP id u27mr1532429bkw.61.1265362891126; Fri, 05 Feb 2010 01:41:31 -0800 (PST) In-Reply-To: <3E94D039A2B82544B3E7D48F924B0B255D0F7EB13C@base.imrc.kist.re.kr> References: <3E94D039A2B82544B3E7D48F924B0B255D0F7EB13C@base.imrc.kist.re.kr> From: Ian Lea Date: Fri, 5 Feb 2010 09:41:11 +0000 Message-ID: <8c4e68611002050141n36de6791tbddbbdcccb2be941@mail.gmail.com> Subject: Re: the question about round, truncate To: "pgsql-admin@postgresql.org" Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.67 tagged_above=-10 required=5 tests=AWL=-0.930, BAYES_20=-0.74 X-Spam-Level: X-Archive-Number: 201002/47 X-Sequence-Number: 33650 test=3D> 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 w= rote: > Dear all. > > > > I have a question about round, truncate. > > > > I want to=A0=A0 fix the data like 3-digit decimal after being rounded on = 4-digit > decimal. > > > > Ex. Geometryformat(=91linestring((54.11238742 22.023498293, 35.128937123 > 94.129837123))=92,-1); > > =A0=A0=A0=A0 -------> #######(=91linestring((54.112 22.023, 35.129 94.130= ))=92,-1); > > > > What should I do? > > > > I want to use the round, truncate command. > > > > I=92m sorry my English is poor. > > > > > > Best regards and thanks in advance. > > > > Kevin.