diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-12-21 23:22:55 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-12-21 23:22:55 +0000 |
| commit | 2ddac948f82b7aee5d16bf89a90e57ab99aae603 (patch) | |
| tree | 0431031203beeb776075bb9d80300d03aeb34acd | |
| parent | 3086f6e4f08635dcc395cf02dbd0552005cdf0f8 (diff) | |
| download | postgresql-2ddac948f82b7aee5d16bf89a90e57ab99aae603.tar.gz postgresql-2ddac948f82b7aee5d16bf89a90e57ab99aae603.zip | |
Add documentation example of using interval multiplication with 'days'.
Backpatch to 8.1.X.
| -rw-r--r-- | doc/src/sgml/func.sgml | 8 |
1 files changed, 7 insertions, 1 deletions
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 --> @@ -5209,6 +5209,12 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})'); <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> <entry><literal>interval '03:30:00'</literal></entry> </row> |