diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/datatype.sgml | 6 | ||||
| -rw-r--r-- | doc/src/sgml/func.sgml | 12 |
2 files changed, 13 insertions, 5 deletions
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index d05c93058a0..26521661b7f 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.229 2008/10/03 15:37:18 petere Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.230 2008/10/14 17:12:32 tgl Exp $ --> <chapter id="datatype"> <title id="datatype-title">Data Types</title> @@ -2032,12 +2032,12 @@ January 8 04:05:06 1999 PST </row> <row> <entry><literal>infinity</literal></entry> - <entry><type>timestamp</type></entry> + <entry><type>date</type>, <type>timestamp</type></entry> <entry>later than all other time stamps</entry> </row> <row> <entry><literal>-infinity</literal></entry> - <entry><type>timestamp</type></entry> + <entry><type>date</type>, <type>timestamp</type></entry> <entry>earlier than all other time stamps</entry> </row> <row> diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index e289326f2fb..06ee6a0572f 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.449 2008/10/13 16:25:19 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.450 2008/10/14 17:12:32 tgl Exp $ --> <chapter id="functions"> <title>Functions and Operators</title> @@ -5913,9 +5913,17 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})'); </row> <row> + <entry><literal><function>isfinite</function>(<type>date</type>)</literal></entry> + <entry><type>boolean</type></entry> + <entry>Test for finite date (not +/-infinity)</entry> + <entry><literal>isfinite(date '2001-02-16')</literal></entry> + <entry><literal>true</literal></entry> + </row> + + <row> <entry><literal><function>isfinite</function>(<type>timestamp</type>)</literal></entry> <entry><type>boolean</type></entry> - <entry>Test for finite time stamp (not equal to infinity)</entry> + <entry>Test for finite time stamp (not +/-infinity)</entry> <entry><literal>isfinite(timestamp '2001-02-16 21:28:30')</literal></entry> <entry><literal>true</literal></entry> </row> |