simple SQL question - Mailing list pgsql-general

From Joshua
Subject simple SQL question
Date
Msg-id 467FD19F.1080209@joshuaneil.com
Whole thread Raw
Responses Re: {Spam} simple SQL question  (Dimitri Fontaine <dfontaine@hi-media.com>)
Re: simple SQL question  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: alter table type from double precision to real
Next
From: Dimitri Fontaine
Date:
Subject: Re: {Spam} simple SQL question