Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 4ED78476F6E
	for <pgsql-sql@postgresql.org>; Wed,  8 Jan 2003 09:44:23 -0500 (EST)
Received: from wolff.to (wolff.to [66.93.249.74])
	by postgresql.org (Postfix) with SMTP id 93A12476F6C
	for <pgsql-sql@postgresql.org>; Wed,  8 Jan 2003 09:44:22 -0500 (EST)
Received: (qmail 28096 invoked by uid 500); 8 Jan 2003 14:56:23 -0000
Date: Wed, 8 Jan 2003 08:56:23 -0600
From: Bruno Wolff III <bruno@wolff.to>
To: "Randy D. McCracken" <rdm@srs.fs.usda.gov>
Cc: pgsql-sql@postgresql.org
Subject: Re: Search and Replace
Message-ID: <20030108145623.GA27870@wolff.to>
Mail-Followup-To: "Randy D. McCracken" <rdm@srs.fs.usda.gov>,
	pgsql-sql@postgresql.org
References: <Pine.LNX.4.44.0301081159400.13271-100000@matrix.gatewaynet.com>
	<Pine.LNX.4.44.0301080901150.28293-100000@www.srs.fs.usda.gov>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <Pine.LNX.4.44.0301080901150.28293-100000@www.srs.fs.usda.gov>
User-Agent: Mutt/1.3.25i
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/96
X-Sequence-Number: 10961

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.