diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 38 |
1 files changed, 22 insertions, 16 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index dc927737c31..0c90a01e709 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.291.2.3 2005/12/03 16:45:22 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.291.2.4 2005/12/21 16:02:44 momjian Exp $ PostgreSQL documentation --> @@ -5112,37 +5112,37 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})'); <row> <entry> <literal>+</literal> </entry> <entry><literal>date '2001-09-28' + interval '1 hour'</literal></entry> - <entry><literal>timestamp '2001-09-28 01:00'</literal></entry> + <entry><literal>timestamp '2001-09-28 01:00:00'</literal></entry> </row> <row> <entry> <literal>+</literal> </entry> <entry><literal>date '2001-09-28' + time '03:00'</literal></entry> - <entry><literal>timestamp '2001-09-28 03:00'</literal></entry> + <entry><literal>timestamp '2001-09-28 03:00:00'</literal></entry> </row> <row> <entry> <literal>+</literal> </entry> <entry><literal>interval '1 day' + interval '1 hour'</literal></entry> - <entry><literal>interval '1 day 01:00'</literal></entry> + <entry><literal>interval '1 day 01:00:00'</literal></entry> </row> <row> <entry> <literal>+</literal> </entry> <entry><literal>timestamp '2001-09-28 01:00' + interval '23 hours'</literal></entry> - <entry><literal>timestamp '2001-09-29 00:00'</literal></entry> + <entry><literal>timestamp '2001-09-29 00:00:00'</literal></entry> </row> <row> <entry> <literal>+</literal> </entry> <entry><literal>time '01:00' + interval '3 hours'</literal></entry> - <entry><literal>time '04:00'</literal></entry> + <entry><literal>time '04:00:00'</literal></entry> </row> <row> <entry> <literal>-</literal> </entry> <entry><literal>- interval '23 hours'</literal></entry> - <entry><literal>interval '-23:00'</literal></entry> + <entry><literal>interval '-23:00:00'</literal></entry> </row> <row> @@ -5160,49 +5160,55 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})'); <row> <entry> <literal>-</literal> </entry> <entry><literal>date '2001-09-28' - interval '1 hour'</literal></entry> - <entry><literal>timestamp '2001-09-27 23:00'</literal></entry> + <entry><literal>timestamp '2001-09-27 23:00:00'</literal></entry> </row> <row> <entry> <literal>-</literal> </entry> <entry><literal>time '05:00' - time '03:00'</literal></entry> - <entry><literal>interval '02:00'</literal></entry> + <entry><literal>interval '02:00:00'</literal></entry> </row> <row> <entry> <literal>-</literal> </entry> <entry><literal>time '05:00' - interval '2 hours'</literal></entry> - <entry><literal>time '03:00'</literal></entry> + <entry><literal>time '03:00:00'</literal></entry> </row> <row> <entry> <literal>-</literal> </entry> <entry><literal>timestamp '2001-09-28 23:00' - interval '23 hours'</literal></entry> - <entry><literal>timestamp '2001-09-28 00:00'</literal></entry> + <entry><literal>timestamp '2001-09-28 00:00:00'</literal></entry> </row> <row> <entry> <literal>-</literal> </entry> <entry><literal>interval '1 day' - interval '1 hour'</literal></entry> - <entry><literal>interval '23:00'</literal></entry> + <entry><literal>interval '1 day -01:00:00'</literal></entry> </row> <row> <entry> <literal>-</literal> </entry> <entry><literal>timestamp '2001-09-29 03:00' - timestamp '2001-09-27 12:00'</literal></entry> - <entry><literal>interval '1 day 15:00'</literal></entry> + <entry><literal>interval '1 day 15:00:00'</literal></entry> </row> <row> <entry> <literal>*</literal> </entry> - <entry><literal>interval '1 hour' * double precision '3.5'</literal></entry> - <entry><literal>interval '03:30'</literal></entry> + <entry><literal>900 * interval '1 second'</literal></entry> + <entry><literal>interval '00:15:00'</literal></entry> + </row> + + <row> + <entry> <literal>*</literal> </entry> + <entry><literal>double precision '3.5' * interval '1 hour'</literal></entry> + <entry><literal>interval '03:30:00'</literal></entry> </row> <row> <entry> <literal>/</literal> </entry> <entry><literal>interval '1 hour' / double precision '1.5'</literal></entry> - <entry><literal>interval '00:40'</literal></entry> + <entry><literal>interval '00:40:00'</literal></entry> </row> </tbody> </tgroup> |