Re: [NOVICE] Search and Replace

Поиск
Список
Период
Сортировка
Искать
От
Bruno Wolff III
Тема
Re: [NOVICE] Search and Replace
Дата
Msg-id
20030110003854.GA22030@wolff.to
Ответ на
Re: [SQL] Search and Replace (Randy D. McCracken)
Список
Дерево обсуждения
SQL list table names alviN <gamboa@infophil.com>
Re: SQL list table names Alan Gutierrez <ajglist@izzy.net>
Re: SQL list table names Achilleus Mantzios <achill@matrix.gatewaynet.com>
Search and Replace "Randy D. McCracken" <rdm@srs.fs.usda.gov>
Re: Search and Replace Bruno Wolff III <bruno@wolff.to>
Re: Search and Replace "Ross J. Reedstrom" <reedstrm@rice.edu>
Re: Search and Replace "Randy D. McCracken" <rdm@srs.fs.usda.gov>
Re: Search and Replace "Rajesh Kumar Mallah." <mallah@trade-india.com>
Re: Search and Replace "Ross J. Reedstrom" <reedstrm@rice.edu>
Re: Search and Replace "Randy D. McCracken" <rdm@srs.fs.usda.gov>
Re: [NOVICE] Search and Replace Bruno Wolff III <bruno@wolff.to>
Re: Search and Replace "Rajesh Kumar Mallah." <mallah@trade-india.com>
Re: SQL list table names Adam Witney <awitney@sghms.ac.uk> 
On Thu, Jan 09, 2003 at 19:15:51 -0500,
  "Randy D. McCracken"  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.
В списке pgsql-sql по дате отправления
Предыдущее
От: Randy D. McCracken
Дата:
Сообщение: Re: Search and Replace
Следующее
От: Maurício Sessue Otta
Дата:
FAQ