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 <[EMAIL PROTECTED]> 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>
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
