Postgres Pro
Downloads
Home   >   mailing lists

Thread: Update value to "the first character is capital and the rest is small"

Update value to "the first character is capital and the rest is small"

From
Emi Lu
Date:
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

Re: Update value to "the first character is capital and

From
Emi Lu
Date:
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

Re: Update value to "the first character is capital and

From
John Sidney-Woollett
Date:
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