diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2003-01-29 01:08:42 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2003-01-29 01:08:42 +0000 |
| commit | 23b8a0ce61c0fac72c9b40acb875bb0ab0a5b915 (patch) | |
| tree | acb0ee063927379be7841f30fbb51e397ea75fdb /doc/src | |
| parent | b8add56ed0910c3cb749ec2a6f2f7531a847132e (diff) | |
Repair array subscript overrun identified by Yichen Xie. Reduce the
value of MAX_TIME_PRECISION in floating-point-timestamp-storage case
from 13 to 10, which is as much as time_out is actually willing to print.
(The alternative of increasing the number of digits we are willing to
print looks risky; we might find ourselves printing roundoff garbage.)
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/datatype.sgml | 13 |
1 files changed, 9 insertions, 4 deletions
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index 3d75edca765..9bbd5146c2a 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.111 2003/01/15 18:01:04 momjian Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.112 2003/01/29 01:08:42 tgl Exp $ --> <chapter id="datatype"> @@ -1297,8 +1297,7 @@ SELECT b, char_length(b) FROM test2; fractional digits retained in the seconds field. By default, there is no explicit bound on precision. The allowed range of <replaceable>p</replaceable> is from 0 to 6 for the - <type>timestamp</type> and <type>interval</type> types, 0 to 13 - for the <type>time</type> types. + <type>timestamp</type> and <type>interval</type> types. </para> <note> @@ -1315,6 +1314,12 @@ SELECT b, char_length(b) FROM test2; </note> <para> + For the <type>time</type> types, the allowed range of + <replaceable>p</replaceable> is from 0 to 6 when eight-byte integer + storage is used, or from 0 to 10 when floating-point storage is used. + </para> + + <para> Time zones, and time-zone conventions, are influenced by political decisions, not just earth geometry. Time zones around the world became somewhat standardized during the 1900's, @@ -1485,7 +1490,7 @@ SELECT b, char_length(b) FROM test2; <para> The <type>time</type> type can be specified as <type>time</type> or as <type>time without time zone</type>. The optional precision - <replaceable>p</replaceable> should be between 0 and 13, and + <replaceable>p</replaceable> should be between 0 and 6, and defaults to the precision of the input time literal. </para> |