PostgreSQL SQL - Re: [GENERAL] Update value to "the first character is capital

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: [GENERAL] Update value to "the first character is capital

Emi Lu

2006-03-13, 8:24 pm

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

Alvaro Herrera wrote:

>Emi Lu wrote:
>
>
>
>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)
>
>
>

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Sponsored Links