diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/syntax.sgml | 19 |
1 files changed, 18 insertions, 1 deletions
diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml index 5f82a784851..c6093b84637 100644 --- a/doc/src/sgml/syntax.sgml +++ b/doc/src/sgml/syntax.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/syntax.sgml,v 1.89 2003/11/29 19:51:37 pgsql Exp $ +$PostgreSQL: pgsql/doc/src/sgml/syntax.sgml,v 1.90 2004/03/12 00:25:40 neilc Exp $ --> <chapter id="sql-syntax"> @@ -360,6 +360,23 @@ SELECT 'foo' 'bar'; </para> <para> + In addition, there are several special constant values that are + accepted as numeric constants. The <type>float4</type> and + <type>float8</type> types allow the following special constants: +<literallayout> +Infinity +-Infinity +NaN +</literallayout> + These represent the IEEE 754 special values + <quote>infinity</quote>, <quote>negative infinity</quote>, and + <quote>not-a-number</quote>, respectively. The + <type>numeric</type> type only allows <literal>NaN</>, whereas + the integral types do not allow any of these constants. Note that + these constants are recognized in a case-insensitive manner. + </para> + + <para> <indexterm><primary>integer</primary></indexterm> <indexterm><primary>bigint</primary></indexterm> <indexterm><primary>numeric</primary></indexterm> |