Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 27C6A9FB445 for ; Mon, 25 Jun 2007 11:29:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 56611-07 for ; Mon, 25 Jun 2007 11:29:36 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 0B87F9FB464 for ; Mon, 25 Jun 2007 11:29:42 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from randymail-a5.g.dreamhost.com (sd-green-bigip-83.dreamhost.com [208.97.132.83]) by svr4.postgresql.org (Postfix) with ESMTP id 1830C5AF88F for ; Mon, 25 Jun 2007 14:29:40 +0000 (GMT) Received: from [10.37.75.125] (unknown [204.252.154.241]) by randymail-a5.g.dreamhost.com (Postfix) with ESMTP id 315BC9090F for ; Mon, 25 Jun 2007 07:29:53 -0700 (PDT) Message-ID: <467FD14F.7000302@joshuaneil.com> Date: Mon, 25 Jun 2007 09:29:35 -0500 From: Joshua User-Agent: Thunderbird 1.5.0.12 (Windows/20070509) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: simple SQL question Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.217 tagged_above=0 required=5 tests=AWL=0.216, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200706/190 X-Sequence-Number: 28680 I have a column with the following values (example below) 5673 4731 4462 5422 756 3060 I want the column to display the numbers as follows: 56.73 47.31 44.62 54.22 7.56 30.60 I have been playing around with string functions but cannot seem to figure out a quick solution. Does anyone have any suggestions? Please let me know. Thanks.