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

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: emilu(at)encs(dot)concordia(dot)ca
Cc: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: Update value to "the first character is capital and
Date: 2006-03-13 22:37:36
Message-ID: 4415F430.7060503@encs.concordia.ca
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2006-03-13 22:41:47 Re: Wisconsin Circuit Court Access (WCCA) on PostgreSQL
Previous Message Alvaro Herrera 2006-03-13 22:36:04 Re: [SQL] Update value to "the first character is capital and the rest is small"

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2006-03-13 22:53:54 Re: connectby documentation
Previous Message Alvaro Herrera 2006-03-13 22:36:04 Re: [SQL] Update value to "the first character is capital and the rest is small"