Re: Search and Replace - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: Search and Replace
Date
Msg-id 20030108145623.GA27870@wolff.to
Whole thread Raw
In response to Search and Replace  ("Randy D. McCracken" <rdm@srs.fs.usda.gov>)
List pgsql-sql
On Wed, Jan 08, 2003 at 09:02:47 -0500, "Randy D. McCracken" <rdm@srs.fs.usda.gov> wrote:
> 
> UPDATE publications SET url = 'www.srs.fs.usda.gov' WHERE url =
> 'www.srs.fs.fed.us';

For simple cases you can do this with available string functions.
For more complicated cases, you can write a simple application
that selects records (which means you will need a unique key returned)
based on a regular expression and then the application will issue
updates for the matching records.


pgsql-sql by date:

Previous
From: "Randy D. McCracken"
Date:
Subject: Search and Replace
Next
From: Richard Rowell
Date:
Subject: to_date() confusion