Re: [NOVICE] Search and Replace

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.