diff options
| author | Neil Conway <neilc@samurai.com> | 2007-05-29 04:58:43 +0000 |
|---|---|---|
| committer | Neil Conway <neilc@samurai.com> | 2007-05-29 04:58:43 +0000 |
| commit | 6af04882de5c519d7e49af8e69a031d2b3b46adc (patch) | |
| tree | b134e2f4f34897c2b0fe1a663c3d97d17f9f35f9 /doc/src | |
| parent | e78720ff2f93dcb82484a310d86ce9875385bc20 (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 6b72e80e569..17357d84088 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.201 2007/05/21 17:10:28 petere Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.202 2007/05/29 04:58:43 neilc Exp $ --> <chapter id="datatype"> <title id="datatype-title">Data Types</title> @@ -1880,7 +1880,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>, |