From: Andy Morrow <andy.morrow@jinny.ie>
To: pgsql-sql@postgresql.org
Subject: function replace doesnt exist
Date: Thu, 12 Dec 2002 16:34:48 -0000
Message-ID: <CPEDJLGAFMLAIAPMHNBMGEBECJAA.andy.morrow@jinny.ie> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: andy.morrow@jinny.ie
Subject: Re: function replace doesnt exist
In-Reply-To: <CPEDJLGAFMLAIAPMHNBMGEBECJAA.andy.morrow@jinny.ie>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox