diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2011-07-11 18:49:44 +0300 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2011-07-11 18:49:44 +0300 |
| commit | 3315020a091f64c8d08c3b32a2abd46431dcf857 (patch) | |
| tree | 36428b6b3f06de094d9bfcee6765fcab50469aa1 /doc/src | |
| parent | 75726307e6164673c48d6ce1d143a075b8ce18fa (diff) | |
| download | postgresql-3315020a091f64c8d08c3b32a2abd46431dcf857.tar.gz postgresql-3315020a091f64c8d08c3b32a2abd46431dcf857.zip | |
Fix and clarify information schema interval_precision fields
The fields were previously wrongly typed as character_data; change to
cardinal_number. Update the documentation and the implementation to
show more clearly that this applies to a feature not available in
PostgreSQL, rather than just not yet being implemented in the
information schema.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/information_schema.sgml | 37 |
1 files changed, 26 insertions, 11 deletions
diff --git a/doc/src/sgml/information_schema.sgml b/doc/src/sgml/information_schema.sgml index 77a00cde9bd..85044761d0c 100644 --- a/doc/src/sgml/information_schema.sgml +++ b/doc/src/sgml/information_schema.sgml @@ -488,8 +488,13 @@ <row> <entry><literal>interval_precision</literal></entry> - <entry><type>character_data</type></entry> - <entry>Not yet implemented</entry> + <entry><type>cardinal_number</type></entry> + <entry> + Applies to a feature not available + in <productname>PostgreSQL</productname> + (see <literal>datetime_precision</literal> for the fractional + seconds precision of interval type attributes) + </entry> </row> <row> @@ -1343,8 +1348,13 @@ <row> <entry><literal>interval_precision</literal></entry> - <entry><type>character_data</type></entry> - <entry>Not yet implemented</entry> + <entry><type>cardinal_number</type></entry> + <entry> + Applies to a feature not available + in <productname>PostgreSQL</productname> + (see <literal>datetime_precision</literal> for the fractional + seconds precision of interval type columns) + </entry> </row> <row> @@ -2139,8 +2149,13 @@ <row> <entry><literal>interval_precision</literal></entry> - <entry><type>character_data</type></entry> - <entry>Not yet implemented</entry> + <entry><type>cardinal_number</type></entry> + <entry> + Applies to a feature not available + in <productname>PostgreSQL</productname> + (see <literal>datetime_precision</literal> for the fractional + seconds precision of interval type domains) + </entry> </row> <row> @@ -2400,7 +2415,7 @@ ORDER BY c.ordinal_position; <row> <entry><literal>interval_precision</literal></entry> - <entry><type>character_data</type></entry> + <entry><type>cardinal_number</type></entry> <entry>Always null, since this information is not applied to array element data types in <productname>PostgreSQL</></entry> </row> @@ -3150,7 +3165,7 @@ ORDER BY c.ordinal_position; <row> <entry><literal>interval_precision</literal></entry> - <entry><type>character_data</type></entry> + <entry><type>cardinal_number</type></entry> <entry>Always null, since this information is not applied to parameter data types in <productname>PostgreSQL</></entry> </row> @@ -4037,7 +4052,7 @@ ORDER BY c.ordinal_position; <row> <entry><literal>interval_precision</literal></entry> - <entry><type>character_data</type></entry> + <entry><type>cardinal_number</type></entry> <entry>Always null, since this information is not applied to return data types in <productname>PostgreSQL</></entry> </row> @@ -4369,7 +4384,7 @@ ORDER BY c.ordinal_position; <row> <entry><literal>result_cast_interval_precision</literal></entry> - <entry><type>character_data</type></entry> + <entry><type>cardinal_number</type></entry> <entry>Applies to a feature not available in <productname>PostgreSQL</></entry> </row> @@ -6008,7 +6023,7 @@ ORDER BY c.ordinal_position; <row> <entry><literal>interval_precision</literal></entry> - <entry><type>character_data</type></entry> + <entry><type>cardinal_number</type></entry> <entry>Applies to a feature not available in <productname>PostgreSQL</></entry> </row> |