Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 1DA8D47650C
	for <pgsql-sql@postgresql.org>; Thu, 12 Dec 2002 11:48:31 -0500 (EST)
Received: from beamish.nsd.ca (unknown [205.150.156.194])
	by postgresql.org (Postfix) with ESMTP id A0D1447661B
	for <pgsql-sql@postgresql.org>; Thu, 12 Dec 2002 11:48:00 -0500 (EST)
Received: (from smap@localhost) by beamish.nsd.ca (8.9.3/8.9.3) id LAA06789;
	Thu, 12 Dec 2002 11:48:03 -0500
X-Authentication-Warning: beamish.nsd.ca: smap set sender to <jllachan@nsd.ca>
	using -f
Received: from reddog.nsd.ca(192.168.101.30) by beamish.nsd.ca via smap
	(V2.1/2.1+anti-relay+anti-spam)
	id xma006783; Thu, 12 Dec 02 11:47:42 -0500
Received: from nsd.ca (jllachan-linux.nsd.ca [192.168.101.148])
	by reddog.nsd.ca (8.8.7/8.8.7) with ESMTP id LAA02424;
	Thu, 12 Dec 2002 11:46:12 -0500
Message-ID: <3DF8BDD0.3791CCC5@nsd.ca>
Date: Thu, 12 Dec 2002 11:48:16 -0500
From: Jean-Luc Lachance <jllachan@nsd.ca>
X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.9-31 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Andy Morrow <andy.morrow@jinny.ie>
Cc: pgsql-sql@postgresql.org
Subject: Re: function replace doesnt exist
References: <CPEDJLGAFMLAIAPMHNBMGEBECJAA.andy.morrow@jinny.ie>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200212/164
X-Sequence-Number: 10752

If you want character translation like the tr command under unix, 
use TRANSLATE.




Andy Morrow wrote:
> 
> Hi
> 
> im trying to execute an update command on a postgresql DB table using
> pgAdmin II
> 
> im using the following statement
> 
> UPDATE commandlist SET command = REPLACE (command,'A','B')
> 
> commandlist is the table name
> command is the column
> and i want to change the value A to B
> 
> but it's giving me the following error message
> 
> an error has occured in pgAdmin II:frmSQLInput.cmdExecute_Click:
> 
> Number: -2147467259
> Description: Error while executing the query;
> ERROR: Function'replace(varchar, unknown, unknown)' does not exist
> Unable to identify a function that satisfies the given argument types
> You may need to add explicit typecasts
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly