Here is a small doc patch that says that initcap lowercases the rest of
the characters in the string. The current doc suggests that it only
touches the first character in each word, which is not what the function
does.
Maybe we should change the example to be 'hi THOMAS' instead of 'hi
thomas'.
Is it okay for me to commit this?
--
/Dennis Björklund
Index: func.sgml
===================================================================
RCS file: /cvsroot/pgsql-server/doc/src/sgml/func.sgml,v
retrieving revision 1.187
diff -u -r1.187 func.sgml
--- func.sgml 22 Feb 2004 04:14:06 -0000 1.187
+++ func.sgml 26 Feb 2004 21:57:36 -0000
@@ -1109,7 +1109,10 @@
<row>
<entry><literal><function>initcap</function>(<type>text</type>)</literal></entry>
<entry><type>text</type></entry>
- <entry>Convert first letter of each word (whitespace-separated) to upper
case</entry>
+ <entry>
+ Convert first letter of each word (whitespace-separated) to upper case
+ and the rest to lower case.
+ </entry>
<entry><literal>initcap('hi thomas')</literal></entry>
<entry><literal>Hi Thomas</literal></entry>
</row>
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
