Re: using Replace funcion in postgresql - Mailing list pgsql-general

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@gmail.com