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 по дате отправления: