Quick Links

using Replace funcion in postgresql

From:	karinos57 <karinos57(at)hotmail(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	using Replace funcion in postgresql
Date:	2013-09-16 23:55:52
Message-ID:	1379375752969-5771164.post@n5.nabble.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

Re: using Replace funcion in postgresql at 2013-09-17 01:09:14 from John R Pierce
Re: using Replace funcion in postgresql at 2013-09-17 01:22:50 from Adrian Klaver
Re: using Replace funcion in postgresql at 2013-09-17 05:00:42 from David Johnston

	From	Date	Subject
Next Message	Ken Tanzer	2013-09-17 00:32:05	Why does this array query fail?
Previous Message	NWRFC Portland	2013-09-16 20:40:15	Re: Postgres 9.2.4 "Double Precision" Precision