diff options
| author | Bruce Momjian <bruce@momjian.us> | 2007-02-20 00:25:16 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2007-02-20 00:25:16 +0000 |
| commit | d9341ce1b8dfb92afae33adb088f00aae5cecbbe (patch) | |
| tree | 2132af70c008c0dba12910e3ce83c082aa494be9 | |
| parent | c2039e4477c25f2cfcc184d7653e35abeaeeecd3 (diff) | |
Document IS [NOT] OF, which was added in 7.3.
| -rw-r--r-- | doc/src/sgml/func.sgml | 18 | ||||
| -rw-r--r-- | doc/src/sgml/syntax.sgml | 5 |
2 files changed, 20 insertions, 3 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index b00b139002c..f125f376883 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.347.2.3 2007/01/30 22:29:40 momjian Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.347.2.4 2007/02/20 00:25:16 momjian Exp $ --> <chapter id="functions"> <title>Functions and Operators</title> @@ -411,6 +411,22 @@ <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"> diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml index 65c29b835cc..fb064151b30 100644 --- a/doc/src/sgml/syntax.sgml +++ b/doc/src/sgml/syntax.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/syntax.sgml,v 1.111 2006/10/22 03:03:41 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/syntax.sgml,v 1.111.2.1 2007/02/20 00:25:16 momjian Exp $ --> <chapter id="sql-syntax"> <title>SQL Syntax</title> @@ -847,7 +847,8 @@ SELECT (5 !) - 6; <row> <entry><token>IS</token></entry> <entry></entry> - <entry><literal>IS TRUE</>, <literal>IS FALSE</>, <literal>IS UNKNOWN</>, <literal>IS NULL</></entry> + <entry><literal>IS TRUE</>, <literal>IS FALSE</>, <literal>IS + UNKNOWN</>, <literal>IS NULL</>, <literal>IS OF</></entry> </row> <row> |