Re: {Spam} simple SQL question - Mailing list pgsql-general

From Dimitri Fontaine
Subject Re: {Spam} simple SQL question
Date
Msg-id 200706251644.22848.dfontaine@hi-media.com
Whole thread Raw
In response to simple SQL question  (Joshua <joshua@joshuaneil.com>)
List pgsql-general
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), (3060)) as x(a);
 ?column?
----------
    56.73
    47.31
    44.62
    54.22
     7.56
     30.6
(6 lignes)

--
dim

Attachment

pgsql-general by date:

Previous
From: Joshua
Date:
Subject: simple SQL question
Next
From: Tom Lane
Date:
Subject: Re: Experiences of PostgreSQL on-disk bitmap index patch