Re: {Spam} simple SQL question

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: {Spam} simple SQL question
Date: 2007-06-25 14:44:20
Message-ID: 200706251644.22848.dfontaine@hi-media.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-06-25 14:58:56 Re: Experiences of PostgreSQL on-disk bitmap index patch
Previous Message Joshua 2007-06-25 14:30:55 simple SQL question