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.