Re: using Replace funcion in postgresql

Adrian Klaver <adrian.klaver@xxxxxxxxx> · Mon, 16 Sep 2013 18:22:50 -0700

On 09/16/2013 04:55 PM, karinos57 wrote:
SELECT
        Volume, REPLACE(Volume,'.','')
       FROM MyTable

The data in my table looks like this:

88.97
448.58 and etc

i want to show like this with out the period:

8897
44858

I have tried to use different ways but still getting the error i hope
someone out there can help me. How can i achieve this? thanks

SELECT
         Volume, REPLACE(Volume::text,'.','')::int
        FROM MyTable

--
Adrian Klaver
adrian.klaver@xxxxxxxxx

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general