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
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
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