Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M37221=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1UKTyn-0006DD-5m
	for pgsql-sql@arkaria.postgresql.org; Tue, 26 Mar 2013 13:31:57 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M37221=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1UKTym-0000kW-Ls
	for pgsql-sql@arkaria.postgresql.org; Tue, 26 Mar 2013 13:31:56 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <jsharrett@proferi.com>) id 1UKTyl-0000je-If
	for pgsql-sql@postgresql.org; Tue, 26 Mar 2013 13:31:55 +0000
Received: from mail-pb0-f47.google.com ([209.85.160.47])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <jsharrett@proferi.com>) id 1UKTyi-0005UQ-Ca
	for pgsql-sql@postgresql.org; Tue, 26 Mar 2013 13:31:55 +0000
Received: by mail-pb0-f47.google.com with SMTP id rp2so4716413pbb.6
	for <pgsql-sql@postgresql.org>; Tue, 26 Mar 2013 06:31:50 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
	d=google.com; s=20120113;
	h=x-received:user-agent:date:subject:from:to:message-id:thread-topic
	:in-reply-to:mime-version:content-type:content-transfer-encoding
	:x-gm-message-state;
	bh=mlrsouerwtf1WgQSWg010NNc3mYExcLNuq3vO2sYCNE=;
	b=DmnPzloLZY4D+Ibvpjtj2ENOVvsuBddSBYOUVE65zYw60AvBsXTVKvyxz/oL923t3X
	3Ppjahix1vGnRn1vFmVbcZB5tZhgTUfMDwLakMnRMr/b99aW6wj5WLG955GQhAYq5dGy
	xevFhYFAEThJczfrQuxJLXlYGeyv9PTl/uzNcAfMkdv2mxPPuSh7L0AyPjk78QZmp8qV
	Nze1sJ4OX4+iQoCD7ETZqFV6z3J4tYjhEzRIPMRWeM/Kvi/7FZ+xZH/yrzeXfRCekafk
	CFwoPvYxiJ3aYF/oDEY4cBtfJycyFSov4Ns0nfY/BdXubOK/5I4YDyLtXWzd3hLCFsPJ
	q/6A==
X-Received: by 10.68.7.163 with SMTP id k3mr23434993pba.141.1364304710371;
	Tue, 26 Mar 2013 06:31:50 -0700 (PDT)
Received: from [10.0.1.10] (adsl-074-245-040-156.sip.clt.bellsouth.net.
	[74.245.40.156]) by mx.google.com with ESMTPS id
	wl14sm19208355pac.18.2013.03.26.06.31.47
	(version=TLSv1 cipher=RC4-SHA bits=128/128);
	Tue, 26 Mar 2013 06:31:49 -0700 (PDT)
User-Agent: Microsoft-MacOutlook/14.3.2.130206
Date: Tue, 26 Mar 2013 09:31:41 -0400
Subject: Re: how can I replace all instances of a pattern
From: James Sharrett <jsharrett@tidemark.net>
To: <pgsql-sql@postgresql.org>
Message-ID: <CD771B49.8A85%jsharrett@tidemark.net>
Thread-Topic: [SQL] how can I replace all instances of a pattern
In-Reply-To: <20130326131852.GF32580@aart.rice.edu>
Mime-version: 1.0
Content-type: text/plain;
	charset="US-ASCII"
Content-transfer-encoding: 7bit
X-Gm-Message-State: 
 ALoCoQnsoW5MbdmBMNduSb+LHNePevX/0yXTsL3pIB+SQl+VCd425kB+KZ0SohjXskhR9JqjeJ4m
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

Thanks Ken!  I missed that option going through the documentation.

>




-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql