From: | Emi Lu <emilu(at)encs(dot)concordia(dot)ca> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
Subject: | Update value to "the first character is capital and the rest is small" |
Date: | 2006-03-13 22:31:28 |
Message-ID: | 4415F2C0.3040707@encs.concordia.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
Hello all,
Does anyone have available plpgsql codes to update all capital letters
in a column to "the first character is capital and the rest is small" ?
For example, in tableA(id, description)
001, 'ZHANG ZHE XIN' =>
'Zhang Zhe Xin'
002, 'LIU, WEI-HUAI'
=> 'Liu, Wei-Huai'
003, 'GU & WEI. NAN (CE SHI) & TOMMORROW' => 'Gu & Wei. Nan (Ce
Shi) & Tommorrow'
Thanks a lot!
Ying
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2006-03-13 22:36:04 | Re: [SQL] Update value to "the first character is capital and the rest is small" |
Previous Message | Michael Schmidt | 2006-03-13 22:28:23 | Re: Wisconsin Circuit Court Access (WCCA) on PostgreSQL |
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2006-03-13 22:36:04 | Re: [SQL] Update value to "the first character is capital and the rest is small" |
Previous Message | Daniel Caune | 2006-03-13 21:56:39 | Re: connectby documentation |