diff options
author | Neil Conway | 2007-05-29 04:59:44 +0000 |
---|---|---|
committer | Neil Conway | 2007-05-29 04:59:44 +0000 |
commit | 21b8d51de66c5d47a647d4ac8307b1846120bd46 (patch) | |
tree | 65a57b7d165becab7fe975cad210592664f34e1f /doc/src | |
parent | 9ccf784833d6ff0a1d89a8eb68094767cc1c1396 (diff) |
Fix a bug in input processing for the "interval" type. Previously,
"microsecond" and "millisecond" units were not considered valid input
by themselves, which caused inputs like "1 millisecond" to be rejected
erroneously.
Update the docs, add regression tests, and backport to 8.2 and 8.1
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/datatype.sgml | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index 8e353aaf702..072c96d44f4 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.163.2.3 2006/08/21 16:24:02 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.163.2.4 2007/05/29 04:59:44 neilc Exp $ --> <chapter id="datatype"> @@ -1823,7 +1823,8 @@ January 8 04:05:06 1999 PST </programlisting> Where: <replaceable>quantity</> is a number (possibly signed); - <replaceable>unit</> is <literal>second</literal>, + <replaceable>unit</> is <literal>microsecond</literal>, + <literal>millisecond</literal>, <literal>second</literal>, <literal>minute</literal>, <literal>hour</literal>, <literal>day</literal>, <literal>week</literal>, <literal>month</literal>, <literal>year</literal>, <literal>decade</literal>, <literal>century</literal>, <literal>millennium</literal>, |