function replace doesnt exist

From: "Andy Morrow" <andy(dot)morrow(at)jinny(dot)ie>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: function replace doesnt exist
Date: 2002-12-12 16:34:48
Message-ID: CPEDJLGAFMLAIAPMHNBMGEBECJAA.andy.morrow@jinny.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jean-Luc Lachance 2002-12-12 16:48:16 Re: function replace doesnt exist
Previous Message Roberto Mello 2002-12-12 16:33:31 Re: Stored Procedure Problem