From 2469b996652f4ae30e9808ca0b06e3ac8e3a039f Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Wed, 21 Dec 2005 16:02:44 +0000 Subject: [PATCH] Add additional example for interval multiplication. Fix example for day and hours interval subtraction for new computation method. Update interval examples to display zero seconds, which is our default. Backpatch to 8.1.X. --- doc/src/sgml/func.sgml | 38 ++++++++++++++++++++++---------------- 1 file changed, 22 insertions(+), 16 deletions(-) diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index dc927737c3..0c90a01e70 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,5 +1,5 @@ @@ -5112,37 +5112,37 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})'); + date '2001-09-28' + interval '1 hour' - timestamp '2001-09-28 01:00' + timestamp '2001-09-28 01:00:00' + date '2001-09-28' + time '03:00' - timestamp '2001-09-28 03:00' + timestamp '2001-09-28 03:00:00' + interval '1 day' + interval '1 hour' - interval '1 day 01:00' + interval '1 day 01:00:00' + timestamp '2001-09-28 01:00' + interval '23 hours' - timestamp '2001-09-29 00:00' + timestamp '2001-09-29 00:00:00' + time '01:00' + interval '3 hours' - time '04:00' + time '04:00:00' - - interval '23 hours' - interval '-23:00' + interval '-23:00:00' @@ -5160,49 +5160,55 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})'); - date '2001-09-28' - interval '1 hour' - timestamp '2001-09-27 23:00' + timestamp '2001-09-27 23:00:00' - time '05:00' - time '03:00' - interval '02:00' + interval '02:00:00' - time '05:00' - interval '2 hours' - time '03:00' + time '03:00:00' - timestamp '2001-09-28 23:00' - interval '23 hours' - timestamp '2001-09-28 00:00' + timestamp '2001-09-28 00:00:00' - interval '1 day' - interval '1 hour' - interval '23:00' + interval '1 day -01:00:00' - timestamp '2001-09-29 03:00' - timestamp '2001-09-27 12:00' - interval '1 day 15:00' + interval '1 day 15:00:00' * - interval '1 hour' * double precision '3.5' - interval '03:30' + 900 * interval '1 second' + interval '00:15:00' + + + + * + double precision '3.5' * interval '1 hour' + interval '03:30:00' / interval '1 hour' / double precision '1.5' - interval '00:40' + interval '00:40:00' -- 2.50.1