diff options
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> |