On Mon, 25 Jun 2007, Joshua wrote:
I have a column with the following values (example below)
5673
4731
4462
5422
756
3060
Are these numbers that will be used in calculations, or are they strings?
I want the column to display the numbers as follows:
56.73
47.31
44.62
54.22
7.56
30.60
Le lundi 25 juin 2007, Joshua a écrit :
> 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.
What about:
pgloader=# select a::float / 100 from (values(5673), (4731), (4462), (5422),
(756), (
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
