| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | "Randy D(dot) McCracken" <rdm(at)srs(dot)fs(dot)usda(dot)gov> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Search and Replace |
| Date: | 2003-01-08 14:56:23 |
| Message-ID: | 20030108145623.GA27870@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-sql |
On Wed, Jan 08, 2003 at 09:02:47 -0500,
"Randy D. McCracken" <rdm(at)srs(dot)fs(dot)usda(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajesh Kumar Mallah. | 2003-01-08 15:37:00 | Re: Search and Replace |
| Previous Message | Randy D. McCracken | 2003-01-08 14:02:47 | Search and Replace |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-01-08 15:06:03 | Re: to_date() confusion |
| Previous Message | Richard Rowell | 2003-01-08 14:49:00 | to_date() confusion |