Обсуждение: remove everything before the period

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    ;




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/remove-everything-before-the-period-tp5771179.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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.broccolo@2ndQuadrant.it | www.2ndQuadrant.it