Thread: Update value to "the first character is capital and the rest is small"
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
Re: [SQL] Update value to "the first character is capital and the rest is small"
From
Alvaro Herrera
Date:
Emi Lu wrote: > 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" ? I don't know about plpgsql codes, but there is a function initcap() that you can use for that. alvherre=# select initcap('GU & WEI. NAN (CE SHI) & TOMMORROW'); initcap ------------------------------------ Gu & Wei. Nan (Ce Shi) & Tommorrow (1 row) -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
I got the answer from the docs. |initcap|(text) thanks anyway, Ying > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings
Have you tried the initcap function? select initcap('abcd efgh'); initcap ----------- Abcd Efgh John Emi Lu wrote: > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings