[GENERAL] remove everything before the period

2013-09-17 Thread karinos57
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 se

Re: [GENERAL] remove everything before the period

2013-09-17 Thread Giuseppe Broccolo
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

Re: [GENERAL] remove everything before the period

2013-09-18 Thread Agustin Larreinegabe
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.brocc...@2ndquadrant.it> wrote: > Il 17/09/2013 04:21, karinos57 ha scritto: > > Hi, >> I am trying to remove everything be