regexp_replace usage

From: chester c young <chestercyoung(at)yahoo(dot)com>
To: sql pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: regexp_replace usage
Date: 2006-09-29 21:31:12
Message-ID: 20060929213112.13312.qmail@web54315.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message chester c young 2006-09-29 22:00:15 tree-structured query
Previous Message Gregory S. Williamson 2006-09-29 02:12:16 Re: files or DataBase