postgres.git / summary / log / commit / refs
commit 9af075c4e27ebe8d18e9b4f4bbd6b88ae73bd61a
Author: Alexander Korotkov <akorotkov@postgresql.org>
Date: Tue Jul 29 07:41:13 2025 +0000
First released in: REL_13_STABLE (reverted before release), REL_14_STABLE (reverted before release), REL_15_STABLE (reverted before release), REL_16_STABLE (reverted before release), REL_17_STABLE (reverted before release), REL_18_STABLE (reverted before release)
Reverted by: 06633271ec40 (in 13.22), 0edaaa8f2978 (in 14.19), 098c27dee4c1 (in 15.14), b862465dba33 (in 16.10), 3b3aa1f651c7 (in 17.6), 2ae8280d16c9 (in 18.0)
Clarify documentation for the initcap function
This commit documents differences in the definition of word separators for
the initcap function between libc and ICU locale providers.
Backpatch to all supported branches.
Discussion: https://postgr.es/m/804cc10ef95d4d3b298e76b181fd9437%40postgrespro.ru
Author: Oleg Tselebrovskiy <o.tselebrovskiy@postgrespro.ru>
Backpatch-through: 13
doc/src/sgml/func.sgml | 7 +++++--
1 file changed, 5 insertions(+), 2 deletions(-)
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index db22327ac12..de8c07aa86e 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -2904,8 +2904,11 @@ repeat('Pg', 4) <returnvalue>PgPgPgPg</returnvalue>
</para>
<para>
Converts the first letter of each word to upper case and the
- rest to lower case. Words are sequences of alphanumeric
- characters separated by non-alphanumeric characters.
+ rest to lower case. When using the <literal>libc</literal> locale
+ provider, words are sequences of alphanumeric characters separated
+ by non-alphanumeric characters; when using the ICU locale provider,
+ words are separated according to
+ <ulink url="https://www.unicode.org/reports/tr29/#Word_Boundaries">Unicode Standard Annex #29</ulink>.
</para>
<para>
<literal>initcap('hi THOMAS')</literal>
[parent: 0ffbd345e43d]