diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2004-12-01 19:32:12 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2004-12-01 19:32:12 +0000 |
| commit | 4828445d3c6687bb43061ac9234b5a3f5d96522b (patch) | |
| tree | ca43f52d926af49d735dcf7860aaea8ddda0a50c /doc/src | |
| parent | 5374d097de4d7321f03df7899816e61502438b32 (diff) | |
| download | postgresql-4828445d3c6687bb43061ac9234b5a3f5d96522b.tar.gz postgresql-4828445d3c6687bb43061ac9234b5a3f5d96522b.zip | |
Clarify documentation of age() functions.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 19 |
1 files changed, 10 insertions, 9 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 111000086d8..52bd7293ca0 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.224 2004/11/27 21:27:06 petere Exp $ +$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.225 2004/12/01 19:32:12 tgl Exp $ PostgreSQL documentation --> @@ -4877,19 +4877,20 @@ substring('foobar' from 'o(.)b') <lineannotation>o</lineannotation> <tbody> <row> - <entry><literal><function>age</function>(<type>timestamp</type>)</literal></entry> + <entry><literal><function>age</function>(<type>timestamp</type>, <type>timestamp</type>)</literal></entry> <entry><type>interval</type></entry> - <entry>Subtract from today</entry> - <entry><literal>age(timestamp '1957-06-13')</literal></entry> - <entry><literal>43 years 8 mons 3 days</literal></entry> + <entry>Subtract arguments, producing a <quote>symbolic</> result that + uses years and months</entry> + <entry><literal>age(timestamp '2001-04-10', timestamp '1957-06-13')</literal></entry> + <entry><literal>43 years 9 mons 27 days</literal></entry> </row> <row> - <entry><literal><function>age</function>(<type>timestamp</type>, <type>timestamp</type>)</literal></entry> + <entry><literal><function>age</function>(<type>timestamp</type>)</literal></entry> <entry><type>interval</type></entry> - <entry>Subtract arguments</entry> - <entry><literal>age('2001-04-10', timestamp '1957-06-13')</literal></entry> - <entry><literal>43 years 9 mons 27 days</literal></entry> + <entry>Subtract from <function>current_date</function></entry> + <entry><literal>age(timestamp '1957-06-13')</literal></entry> + <entry><literal>43 years 8 mons 3 days</literal></entry> </row> <row> |