On Thu, Jan 09, 2003 at 19:15:51 -0500, "Randy D. McCracken" <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
