postgres.git / summary / log / commit / refs
commit 2ddac948f82b7aee5d16bf89a90e57ab99aae603
Author: Bruce Momjian <bruce@momjian.us>
Date: Wed Dec 21 23:22:55 2005 +0000
First released in: 8.2.0, 8.1.2
Add documentation example of using interval multiplication with 'days'.
Backpatch to 8.1.X.
doc/src/sgml/func.sgml | 8 +++++++-
1 file changed, 7 insertions(+), 1 deletion(-)
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 914d6d64a31..86e01ff113d 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.299 2005/12/21 16:02:24 momjian Exp $
+$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.300 2005/12/21 23:22:55 momjian Exp $
PostgreSQL documentation
-->
@@ -5207,6 +5207,12 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})');
<entry><literal>interval '00:15:00'</literal></entry>
</row>
+ <row>
+ <entry> <literal>*</literal> </entry>
+ <entry><literal>21 * interval '1 day'</literal></entry>
+ <entry><literal>interval '21 days'</literal></entry>
+ </row>
+
<row>
<entry> <literal>*</literal> </entry>
<entry><literal>double precision '3.5' * interval '1 hour'</literal></entry>
[parent: 3086f6e4f086]