Skip site navigation (1)
Skip section navigation (2)
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.
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 29 Sep 2006 14:31:12 -0700 (PDT)
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.
- Prev by Date: Re: files or DataBase
- Next by Date: tree-structured query
- Previous by thread: files or DataBase
- Next by thread: tree-structured query
- Indexes: