function replace doesnt exist

Поиск
Список
Период
Сортировка
От Andy Morrow
Тема function replace doesnt exist
Дата
Msg-id CPEDJLGAFMLAIAPMHNBMGEBECJAA.andy.morrow@jinny.ie
обсуждение исходный текст
Ответы Re: function replace doesnt exist
Re: function replace doesnt exist
Список 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



В списке pgsql-sql по дате отправления: