Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id B73519FA3DA
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 25 Jun 2007 11:35:35 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 21476-04-2 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 25 Jun 2007 11:35:20 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from an-out-0708.google.com (an-out-0708.google.com
 [209.85.132.244])
	by postgresql.org (Postfix) with ESMTP id 531149FB96C
	for <pgsql-sql@postgresql.org>; Mon, 25 Jun 2007 11:35:20 -0300 (ADT)
Received: by an-out-0708.google.com with SMTP id c36so308796ana
	for <pgsql-sql@postgresql.org>; Mon, 25 Jun 2007 07:35:16 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=Xv4Wxd563NwGEWtceDdRkAt0S/b3k9IywCw1oIQDqIlBpvDW0vHoz+pEO/XDTUqcennxQYg0LzxioV4ILg0NZU0YF0yaU4+ue1ocgZmnF6u5hQTpgY6YYvXeoxcA4s8NWJWYYSqbP9bHeslhdg5aivrRH8BLtn06McwvAADO46o=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=OVqowduT/qgvugEzAW64+olP373wwKKEQxfwpvKqaPubL3pxo6CM16RhMPre99piJMQwziq3thzX23mbtxRQdYeV3+I6C5GzDckw/KxYS5VdwjmsgOMqwsk4yO3aTzMtDPL+Kmkr3vl9YizojVYUlNxR6WGwyoEeaJFNseoEXYY=
Received: by 10.100.119.14 with SMTP id r14mr3188126anc.1182782116184;
	Mon, 25 Jun 2007 07:35:16 -0700 (PDT)
Received: by 10.100.33.20 with HTTP; Mon, 25 Jun 2007 07:35:16 -0700 (PDT)
Message-ID: <a55915760706250735m843f8b8r4bd91c90dc69b7f6@mail.gmail.com>
Date: Mon, 25 Jun 2007 09:35:16 -0500
From: "=?UTF-8?Q?Rodrigo_De_Le=C3=B3n?=" <rdeleonp@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: simple SQL question
In-Reply-To: <467FD14F.7000302@joshuaneil.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <467FD14F.7000302@joshuaneil.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200706/191
X-Sequence-Number: 28681

On 6/25/07, Joshua <joshua@joshuaneil.com> wrote:
> 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.

Divide by 100.