regexp_replace usage - Mailing list pgsql-sql

From chester c young
Subject regexp_replace usage
Date
Msg-id 20060929213112.13312.qmail@web54315.mail.yahoo.com
Whole thread Raw
Responses Re: regexp_replace usage  (Michael Fuhr <mike@fuhr.org>)
List pgsql-sql
column name in table bue has miscapitalized Mc names, eg, 'John Mcneil' instead of 'John McNeil'.<br /><br />(this
shouldbe easy but) how do you construct the update query?<br /><br />also, regexp_string( 'Mcneil', 'Mc(.*)',
initcap('\\1')) => 'neil' _not_ Neil' - is this correct?<br /><p><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
amore powerful email and get things done faster. 

pgsql-sql by date:

Previous
From: "Gregory S. Williamson"
Date:
Subject: Re: files or DataBase
Next
From: chester c young
Date:
Subject: tree-structured query