| 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: | Whole Thread | Raw Message | 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
| 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 |