| 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: | Raw Message | Whole Thread | 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
| 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" |
| 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" |