The doc for the trim functions does not say that the second argument can
be omitted. This patch fixes it. It also fixes that the type text was not
wrapped as <type>text</type>.
I can not build the docs myself, but i'm pretty sure it's correct.
Is it okay to commit this? Should I do it on the 7.4 branch also, before
the release?
--
/Dennis Björklund
Index: func.sgml
===================================================================
RCS file: /cvsroot/pgsql-server/doc/src/sgml/func.sgml,v
retrieving revision 1.189
diff -u -r1.189 func.sgml
--- func.sgml 29 Feb 2004 15:45:53 -0000 1.189
+++ func.sgml 4 Mar 2004 18:03:18 -0000
@@ -1157,11 +1157,13 @@
</row>
<row>
- <entry><literal><function>ltrim</function>(<parameter>string</parameter>
<type>text</type>, <parameter>characters</parameter>
<type>text</type>)</literal></entry>
+ <entry><literal><function>ltrim</function>(<parameter>string</parameter>
<type>text</type>
+ <optional>, <parameter>characters</parameter>
<type>text</type></optional>)</literal>
+ </entry>
<entry><type>text</type></entry>
<entry>
Remove the longest string containing only characters from
- <parameter>characters</parameter> from the start of
+ <parameter>characters</parameter> (a space by default) from the start of
<parameter>string</parameter>.
</entry>
<entry><literal>ltrim('zzzytrim', 'xyz')</literal></entry>
@@ -1255,12 +1257,13 @@
</row>
<row>
- <entry><literal><function>rtrim</function>(<parameter>string</parameter>
- text, <parameter>characters</parameter> text)</literal></entry>
+ <entry><literal><function>rtrim</function>(<parameter>string</parameter>
<type>text</type>
+ <optional>, <parameter>characters</parameter>
<type>text</type></optional>)</literal>
+ </entry>
<entry><type>text</type></entry>
<entry>
Remove the longest string containing only characters from
- <parameter>characters</parameter> from the end of
+ <parameter>characters</parameter> (a space by default) from the end of
<parameter>string</parameter>.
</entry>
<entry><literal>rtrim('trimxxxx', 'x')</literal></entry>
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
