Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 327291337BBA
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 11 May 2011 17:29:49 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 99964-09 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 11 May 2011 20:29:42 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from stan.prospectivdirect.com (mail.prospectiv.com
 [155.212.59.212])
	by mail.postgresql.org (Postfix) with SMTP id CC7B31337BA8
	for <pgsql-sql@postgresql.org>; Wed, 11 May 2011 17:29:41 -0300 (ADT)
Received: (qmail 27451 invoked from network); 11 May 2011 20:29:40 -0000
Received: from unknown (HELO ?192.168.1.87?) (192.168.1.87)
	by 0 with SMTP; 11 May 2011 20:29:40 -0000
Subject: replace " with nothing
From: Tony Capobianco <tcapobianco@prospectiv.com>
To: pgsql-sql@postgresql.org
Content-Type: text/plain; charset="UTF-8"
Date: Wed, 11 May 2011 16:29:40 -0400
Message-ID: <1305145780.1954.4.camel@tony1.localdomain>
Mime-Version: 1.0
X-Mailer: Evolution 2.32.2 (2.32.2-1.fc14) 
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.011 tagged_above=-5 required=5
	tests=BAYES_40=-0.001, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201105/76
X-Sequence-Number: 35360

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.