Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 4E03A475F37
	for <pgsql-novice@postgresql.org>; Thu,  9 Jan 2003 19:26:52 -0500 (EST)
Received: from wolff.to (wolff.to [66.93.249.74])
	by postgresql.org (Postfix) with SMTP id 92219475D17
	for <pgsql-novice@postgresql.org>; Thu,  9 Jan 2003 19:26:51 -0500 (EST)
Received: (qmail 22037 invoked by uid 500); 10 Jan 2003 00:38:54 -0000
Date: Thu, 9 Jan 2003 18:38:54 -0600
From: Bruno Wolff III <bruno@wolff.to>
To: "Randy D. McCracken" <rdm@srs.fs.usda.gov>
Cc: "Ross J. Reedstrom" <reedstrm@rice.edu>,
	"Rajesh Kumar Mallah." <mallah@trade-india.com>,
	pgsql-sql@postgresql.org, pgsql-novice@postgresql.org
Subject: Re: [SQL] Search and Replace
Message-ID: <20030110003854.GA22030@wolff.to>
Mail-Followup-To: "Randy D. McCracken" <rdm@srs.fs.usda.gov>,
	"Ross J. Reedstrom" <reedstrm@rice.edu>,
	"Rajesh Kumar Mallah." <mallah@trade-india.com>,
	pgsql-sql@postgresql.org, pgsql-novice@postgresql.org
References: <20030109230322.GC30740@wallace.ece.rice.edu>
	<Pine.LNX.4.44.0301091911270.6431-100000@www.srs.fs.fed.us>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <Pine.LNX.4.44.0301091911270.6431-100000@www.srs.fs.fed.us>
User-Agent: Mutt/1.3.25i
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/39
X-Sequence-Number: 5697

On Thu, Jan 09, 2003 at 19:15:51 -0500,
  "Randy D. McCracken" <rdm@srs.fs.usda.gov> wrote:
> 
> Hi Rajesh,
> 
> I don't know why but the example you gave me did not work.  Here is what
> happened when I tried:
> 
> ==========
> 
> pubs_test=# UPDATE publications SET url = replace( 'www.srs.fs.fed.us' ,
> 'www.srs.fs.usda.gov' , url )  WHERE url ilike '%www.srs.fs.fed.us%';
> 
> ERROR:  Function 'replace(unknown, unknown, text)' does not exist
>         Unable to identify a function that satisfies the given argument types
>         You may need to add explicit typecasts

The arguments to replace were in the wrong order.