diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-12-21 23:23:09 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-12-21 23:23:09 +0000 |
| commit | 14e9a17f0a08a908567867cd77b274320e1280f8 (patch) | |
| tree | e88ea19a3e9b78824ce02bba401d7cf29b63582f /doc/src | |
| parent | 2469b996652f4ae30e9808ca0b06e3ac8e3a039f (diff) | |
| download | postgresql-14e9a17f0a08a908567867cd77b274320e1280f8.tar.gz postgresql-14e9a17f0a08a908567867cd77b274320e1280f8.zip | |
Add documentation example of using interval multiplication with 'days'.
Backpatch to 8.1.X.
Diffstat (limited to 'doc/src')
| -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 0c90a01e709..08c3dcbd507 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.4 2005/12/21 16:02:44 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.291.2.5 2005/12/21 23:23:09 momjian Exp $ PostgreSQL documentation --> @@ -5201,6 +5201,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> |