Re: [GENERAL] Update value to "the first character is capital - Mailing list pgsql-sql

I saw it from the docs as well. Thank you Alvaro :)



Alvaro Herrera wrote:

>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)
>
>  
>