Postgres Pro
Downloads
Home   >   mailing lists

using Replace funcion in postgresql - Mailing list pgsql-general

From karinos57
Subject using Replace funcion in postgresql
Date
Msg-id 1379375752969-5771164.post@n5.nabble.com
Whole thread Raw
Responses Re: using Replace funcion in postgresql  (John R Pierce <pierce@hogranch.com>)
Re: using Replace funcion in postgresql  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: using Replace funcion in postgresql  (David Johnston <polobo@yahoo.com>)
List pgsql-general
Tree view 
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



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/using-Replace-funcion-in-postgresql-tp5771164.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Ken Tanzer
Date:
Subject: Why does this array query fail?
Next
From: bricklen
Date:
Subject: Re: Why does this array query fail?