From: | Agustin Larreinegabe <alarreine(at)gmail(dot)com> |
---|---|
To: | Giuseppe Broccolo <giuseppe(dot)broccolo(at)2ndquadrant(dot)it> |
Cc: | PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: remove everything before the period |
Date: | 2013-09-18 11:21:41 |
Message-ID: | CALQFU6_xVNjNycf2iBekPNr-La6cpy+3So=cxv0paZa29MrJ2Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Try with: Select split_part('897.78','.',2)
http://www.postgresql.org/docs/8.4/static/functions-string.html
On Tue, Sep 17, 2013 at 11:33 AM, Giuseppe Broccolo <
giuseppe(dot)broccolo(at)2ndquadrant(dot)it> wrote:
> Il 17/09/2013 04:21, karinos57 ha scritto:
>
> Hi,
>> I am trying to remove everything before the period in other words i only
>> want to show the values that starts from the period. For instance
>> 897.78 ==> 78
>> 74.25 ==> 25
>> 3657.256 ==> 256
>>
>> well the code below only shows everything before the period but i want to
>> show everything after the period
>>
>> select volume, substring(volume from 1 for position('.' in volume) - 1) as
>> column
>> from MyTable ;
>>
> Try with: " SELECT volume, substring(volume from position('.' in volume) +
> 1) AS column FROM MyTable; "
>
> Giuseppe.
>
> --
> Giuseppe Broccolo - 2ndQuadrant Italy
> PostgreSQL Training, Services and Support
> giuseppe(dot)broccolo(at)2ndQuadrant(dot)**it | www.2ndQuadrant.it
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
>
--
Gracias
-----------------
Agustín Larreinegabe
From | Date | Subject | |
---|---|---|---|
Next Message | François Beausoleil | 2013-09-18 12:05:06 | Query plan for currently executing query? |
Previous Message | Jayadevan M | 2013-09-18 10:00:56 | Moving from 9.2 to 9.3 |