Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 74B57476939 for ; Thu, 12 Dec 2002 11:34:59 -0500 (EST) Received: from homer.jinny.ie (homer.jinny.ie [193.120.171.3]) by postgresql.org (Postfix) with ESMTP id 801654768EF for ; Thu, 12 Dec 2002 11:34:43 -0500 (EST) Received: from andy (unknown [193.120.171.2]) by homer.jinny.ie (Postfix) with SMTP id 170D47FD43 for ; Thu, 12 Dec 2002 16:34:48 +0000 (GMT) From: "Andy Morrow" To: Subject: function replace doesnt exist Date: Thu, 12 Dec 2002 16:34:48 -0000 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/163 X-Sequence-Number: 10751 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