Search Postgresql Archives

simple SQL question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general@xxxxxxxxxxxxxx
Subject: simple SQL question
From: Joshua <joshua@xxxxxxxxxxxxxx>
Date: Mon, 25 Jun 2007 09:30:55 -0500
User-agent: Thunderbird 1.5.0.12 (Windows/20070509)

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 tofigure out a quick solution. Does anyone have any suggestions?


Please let me know.

Thanks.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: simple SQL question
  - From: Rich Shepard
- Re: {Spam} simple SQL question
  - From: Dimitri Fontaine

Prev by Date: Re: alter table type from double precision to real
Next by Date: Re: {Spam} simple SQL question
Previous by thread: postgresql varchar[] data type equivalent in Oracle
Next by thread: Re: {Spam} simple SQL question
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux