|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.224 2004/11/27 21:27:06 petere Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.225 2004/12/01 19:32:12 tgl Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -4877,19 +4877,20 @@ substring('foobar' from 'o(.)b') <lineannotation>o</lineannotation> |
4877 | 4877 |
|
4878 | 4878 | <tbody> |
4879 | 4879 | <row> |
4880 | | -<entry><literal><function>age</function>(<type>timestamp</type>)</literal></entry> |
| 4880 | +<entry><literal><function>age</function>(<type>timestamp</type>, <type>timestamp</type>)</literal></entry> |
4881 | 4881 | <entry><type>interval</type></entry> |
4882 | | -<entry>Subtract from today</entry> |
4883 | | -<entry><literal>age(timestamp '1957-06-13')</literal></entry> |
4884 | | -<entry><literal>43 years 8 mons 3 days</literal></entry> |
| 4882 | +<entry>Subtract arguments, producing a <quote>symbolic</> result that |
| 4883 | +uses years and months</entry> |
| 4884 | +<entry><literal>age(timestamp '2001-04-10', timestamp '1957-06-13')</literal></entry> |
| 4885 | +<entry><literal>43 years 9 mons 27 days</literal></entry> |
4885 | 4886 | </row> |
4886 | 4887 |
|
4887 | 4888 | <row> |
4888 | | -<entry><literal><function>age</function>(<type>timestamp</type>, <type>timestamp</type>)</literal></entry> |
| 4889 | +<entry><literal><function>age</function>(<type>timestamp</type>)</literal></entry> |
4889 | 4890 | <entry><type>interval</type></entry> |
4890 | | -<entry>Subtractarguments</entry> |
4891 | | -<entry><literal>age('2001-04-10',timestamp '1957-06-13')</literal></entry> |
4892 | | -<entry><literal>43 years9 mons27 days</literal></entry> |
| 4891 | +<entry>Subtractfrom <function>current_date</function></entry> |
| 4892 | +<entry><literal>age(timestamp '1957-06-13')</literal></entry> |
| 4893 | +<entry><literal>43 years8 mons3 days</literal></entry> |
4893 | 4894 | </row> |
4894 | 4895 |
|
4895 | 4896 | <row> |
|