diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2011-07-13 20:30:40 +0300 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2011-07-13 20:32:08 +0300 |
| commit | 0527a454ec1801358a1f6d873ae48dcc89a217cf (patch) | |
| tree | e9e765f8cb69d2ee2e1fb32f9a96b427924963d3 /doc/src | |
| parent | 80a1d16935099124047bc6faaf9f549130a172b3 (diff) | |
| download | postgresql-0527a454ec1801358a1f6d873ae48dcc89a217cf.tar.gz postgresql-0527a454ec1801358a1f6d873ae48dcc89a217cf.zip | |
Implement information schema interval_type columns
Also correct reporting of interval precision when field restrictions
are specified in the typmod.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/information_schema.sgml | 30 |
1 files changed, 27 insertions, 3 deletions
diff --git a/doc/src/sgml/information_schema.sgml b/doc/src/sgml/information_schema.sgml index 85044761d0c..063d8fabbb4 100644 --- a/doc/src/sgml/information_schema.sgml +++ b/doc/src/sgml/information_schema.sgml @@ -483,7 +483,15 @@ <row> <entry><literal>interval_type</literal></entry> <entry><type>character_data</type></entry> - <entry>Not yet implemented</entry> + <entry> + If <literal>data_type</literal> identifies an interval type, + this column contains the specification which fields the + intervals include for this attribute, e.g., <literal>YEAR TO + MONTH</literal>, <literal>DAY TO SECOND</literal>, etc. If no + field restrictions were specified (that is, the interval + accepts all fields), and for all other data types, this field + is null. + </entry> </row> <row> @@ -1343,7 +1351,15 @@ <row> <entry><literal>interval_type</literal></entry> <entry><type>character_data</type></entry> - <entry>Not yet implemented</entry> + <entry> + If <literal>data_type</literal> identifies an interval type, + this column contains the specification which fields the + intervals include for this column, e.g., <literal>YEAR TO + MONTH</literal>, <literal>DAY TO SECOND</literal>, etc. If no + field restrictions were specified (that is, the interval + accepts all fields), and for all other data types, this field + is null. + </entry> </row> <row> @@ -2144,7 +2160,15 @@ <row> <entry><literal>interval_type</literal></entry> <entry><type>character_data</type></entry> - <entry>Not yet implemented</entry> + <entry> + If <literal>data_type</literal> identifies an interval type, + this column contains the specification which fields the + intervals include for this domain, e.g., <literal>YEAR TO + MONTH</literal>, <literal>DAY TO SECOND</literal>, etc. If no + field restrictions were specified (that is, the interval + accepts all fields), and for all other data types, this field + is null. + </entry> </row> <row> |