Index: func.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/func.sgml,v
retrieving revision 1.298
diff -c -u -r1.298 func.sgml
--- func.sgml 11 Dec 2005 10:54:27 -0000 1.298
+++ func.sgml 21 Dec 2005 15:59:27 -0000
@@ -5120,37 +5120,37 @@
+
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'
@@ -5168,49 +5168,55 @@
-
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'