From: Jeff Eckermann <jeff_eckermann@yahoo.com>
To: Andy Morrow <andy.morrow@jinny.ie>
To: pgsql-sql@postgresql.org
Subject: Re: function replace doesnt exist
Date: Thu, 12 Dec 2002 12:24:17 -0800 (PST)
Message-ID: <20021212202417.50392.qmail@web20805.mail.yahoo.com> (raw)
In-Reply-To: <CPEDJLGAFMLAIAPMHNBMGEBECJAA.andy.morrow@jinny.ie>
What version are you using? I think "replace" is new
for version 7.3.
As another poster has pointed out, "translate" works
for individual characters. Or you could code up your
own replace using the native functionality of pl/perl
or pl/tcl or such. Or you could just upgrade to 7.3.
--- Andy Morrow <andy.morrow@jinny.ie> wrote:
> 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
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please
> send an appropriate
> subscribe-nomail command to majordomo@postgresql.org
> so that your
> message can get through to the mailing list cleanly
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
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: jeff_eckermann@yahoo.com, andy.morrow@jinny.ie
Subject: Re: function replace doesnt exist
In-Reply-To: <20021212202417.50392.qmail@web20805.mail.yahoo.com>
* 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