From: chester c young <chestercyoung@yahoo.com>
To: sql pgsql <pgsql-sql@postgresql.org>
Subject: regexp_replace usage
Date: Fri, 29 Sep 2006 14:31:12 -0700 (PDT)
Message-ID: <20060929213112.13312.qmail@web54315.mail.yahoo.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: chestercyoung@yahoo.com
Subject: Re: regexp_replace usage
In-Reply-To: <20060929213112.13312.qmail@web54315.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox