Re: ToDo: add documentation for operator IS OF

Pavel Stehule wrote:
> Hello,
>
> I miss doc for this operator

Strang IS [NOT] OF wasn't documented, especially seeing it was added in
PostgreSQL 7.3.  Anyway, documented and backpatched to 8.2.X.

--
  Bruce Momjian  <bruce@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +
Index: doc/src/sgml/func.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/func.sgml,v
retrieving revision 1.365
diff -c -c -r1.365 func.sgml
*** doc/src/sgml/func.sgml    19 Feb 2007 22:51:44 -0000    1.365
--- doc/src/sgml/func.sgml    20 Feb 2007 00:24:15 -0000
***************
*** 411,416 ****
--- 411,432 ----
      <literal>IS NOT NULL</literal>, respectively, except that the input
      expression must be of Boolean type.
     </para>
+
+    <para>
+     <indexterm>
+      <primary>IS OF</primary>
+     </indexterm>
+     <indexterm>
+      <primary>IS NOT OF</primary>
+     </indexterm>
+     It is possible to check the data type of an expression using the
+     constructs
+ <synopsis>
+ <replaceable>expression</replaceable> IS OF (typename, ...)
+ <replaceable>expression</replaceable> IS NOT OF (typename, ...)
+ </synopsis>
+     They return a boolean value based on whether the expression's data
+     type is one of the listed data types.
    </sect1>

    <sect1 id="functions-math">
Index: doc/src/sgml/syntax.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/syntax.sgml,v
retrieving revision 1.115
diff -c -c -r1.115 syntax.sgml
*** doc/src/sgml/syntax.sgml    6 Feb 2007 09:16:07 -0000    1.115
--- doc/src/sgml/syntax.sgml    20 Feb 2007 00:24:15 -0000
***************
*** 847,853 ****
        <row>
         <entry><token>IS</token></entry>
         <entry></entry>
!        <entry><literal>IS TRUE</>, <literal>IS FALSE</>, <literal>IS UNKNOWN</>, <literal>IS NULL</></entry>
        </row>

        <row>
--- 847,854 ----
        <row>
         <entry><token>IS</token></entry>
         <entry></entry>
!        <entry><literal>IS TRUE</>, <literal>IS FALSE</>, <literal>IS
!        UNKNOWN</>, <literal>IS NULL</>, <literal>IS OF</></entry>
        </row>

        <row>