Re: [GENERAL] using Replace funcion in postgresql

[John R Pierce]

On 9/16/2013 4: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

still getting _the_ error?  what error is that?    can we assume your 
table field is a numeric rather than a string value?

you could use   to_char(volume*100, 'FM9999999'), or maybe even just 
(volume*100)::integer



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



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