Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id 00FC09FB210
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 29 Sep 2006 18:31:17 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 86772-08 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 29 Sep 2006 21:31:14 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from web54315.mail.yahoo.com (web54315.mail.yahoo.com
	[206.190.49.125])
	by postgresql.org (Postfix) with SMTP id 2B4349FA5F7
	for <pgsql-sql@postgresql.org>; Fri, 29 Sep 2006 18:31:14 -0300 (ADT)
Received: (qmail 13314 invoked by uid 60001); 29 Sep 2006 21:31:12 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=uE5boQ6MYlmzPut/yA2UoScVJm/K/8tNdEGZdBzHza4ImJovmp6L88bUbYk//WP2uIoN8eRX/Ulj/OhNWhrCXZYmOj6I08mcusvAKex+rRYHPwyijlDNnsP1V2oXDlQ8l/EWA42ybT7Jk3nPa2FGYkRoan5u5Hl2tuV+r97t/2Q=
	;
Message-ID: <20060929213112.13312.qmail@web54315.mail.yahoo.com>
Received: from [68.35.2.64] by web54315.mail.yahoo.com via HTTP;
	Fri, 29 Sep 2006 14:31:12 PDT
Date: Fri, 29 Sep 2006 14:31:12 -0700 (PDT)
From: chester c young <chestercyoung@yahoo.com>
Subject: regexp_replace usage
To: sql pgsql <pgsql-sql@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-621425609-1159565472=:11394"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=3.356 tagged_above=0 required=5
	tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS,
	HTML_MESSAGE
X-Spam-Level: ***
X-Archive-Number: 200609/175
X-Sequence-Number: 26386

--0-621425609-1159565472=:11394
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

column name in table bue has miscapitalized Mc names, eg, 'John Mcneil' instead of 'John McNeil'.

(this should be easy but) how do you construct the update query?

also, regexp_string( 'Mcneil', 'Mc(.*)', initcap('\\1') ) => 'neil' _not_ Neil' - is this correct?

 		
---------------------------------
 All-new Yahoo! Mail - Fire up a more powerful email and get things done faster.
--0-621425609-1159565472=:11394
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

column name in table bue has miscapitalized Mc names, eg, 'John Mcneil' instead of 'John McNeil'.<br><br>(this should be easy but) how do you construct the update query?<br><br>also, regexp_string( 'Mcneil', 'Mc(.*)', initcap('\\1') ) =&gt; 'neil' _not_ Neil' - is this correct?<br><p>&#32;
		<hr size=1><a href="http://us.rd.yahoo.com/evt=43256/*http://advision.webevents.yahoo.com/mailbeta"> All-new Yahoo! Mail </a>- Fire up a more powerful email and get things done faster.
--0-621425609-1159565472=:11394--