replace " with nothing

From: Tony Capobianco <tcapobianco(at)prospectiv(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: replace " with nothing
Date: 2011-05-11 20:29:40
Message-ID: 1305145780.1954.4.camel@tony1.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

We are converting from Oracle to Postgres. An Oracle script contains
this line:

select replace(firstname,'"'), memberid, emailaddress from members;

in an effort to replace the " with nothing. How can I achieve the same
result with Postgres?

Here's the Postgres error I get:

select replace(firstname,'"'), memberid, emailaddress from members;
ERROR: function replace(character varying, unknown) does not exist
LINE 1: select replace(firstname,'"'), memberid, emailaddress from m...

Thanks.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tony Capobianco 2011-05-11 20:51:05 Re: replace " with nothing
Previous Message Theodore Petrosky 2011-05-10 20:51:17 Re: Dates and NULL's`