PostgreSQL/String Functions/initcap

Материал из SQL эксперт
Перейти к: навигация, поиск

initcap(s): Returns the character string s, with each word"s first letter capitalized

   <source lang="sql">

postgres=# postgres=# -- initcap(s): Returns the character string s, with each word"s first letter capitalized postgres=# SELECT initcap("a prospective book title");

        initcap

A Prospective Book Title

(1 row) postgres=# postgres=#

      </source>