On Mon, Aug 12, 2013 at 05:19:30PM -0400, Bruce Momjian wrote:
> Attached are docs that add the new syntax, and mention it is
> non-standard; you can see the output here:
>
> http://momjian.us/tmp/pgsql/functions-string.html#FUNCTIONS-STRING-SQL
>
> We do document three syntaxes for substring() in the same table, one row
> for each, so there is precedent for doing this.
Attached is an updated patch with a proper example. I could move the
extra syntax into the description of the existing trim entry instead.
--
Bruce Momjian <br...@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
new file mode 100644
index 6154621..b21c433
*** a/doc/src/sgml/func.sgml
--- b/doc/src/sgml/func.sgml
***************
*** 1296,1301 ****
--- 1296,1320 ----
<row>
<entry>
<indexterm>
+ <primary>trim</primary>
+ </indexterm>
+ <literal><function>trim(<optional>leading | trailing
+ | both</optional> <optional>from</optional>
+ <parameter>string</parameter>
+ <optional><parameter>, characters</parameter></optional>
+ )</function></literal>
+ </entry>
+ <entry><type>text</type></entry>
+ <entry>
+ Non-standard version of <function>trim()</>
+ </entry>
+ <entry><literal>trim(both from 'xTomxx', 'x')</literal></entry>
+ <entry><literal>Tom</literal></entry>
+ </row>
+
+ <row>
+ <entry>
+ <indexterm>
<primary>upper</primary>
</indexterm>
<literal><function>upper(<parameter>string</parameter>)</function></literal>
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
