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 /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 'src')
| -rw-r--r-- | src/backend/catalog/information_schema.sql | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/src/backend/catalog/information_schema.sql b/src/backend/catalog/information_schema.sql index 966eb08b97d..d7ce8413ab9 100644 --- a/src/backend/catalog/information_schema.sql +++ b/src/backend/catalog/information_schema.sql @@ -322,7 +322,7 @@ CREATE VIEW attributes AS AS datetime_precision, CAST(null AS character_data) AS interval_type, -- FIXME - CAST(null AS character_data) AS interval_precision, -- FIXME + CAST(null AS cardinal_number) AS interval_precision, CAST(current_database() AS sql_identifier) AS attribute_udt_catalog, CAST(nt.nspname AS sql_identifier) AS attribute_udt_schema, @@ -671,7 +671,7 @@ CREATE VIEW columns AS AS datetime_precision, CAST(null AS character_data) AS interval_type, -- FIXME - CAST(null AS character_data) AS interval_precision, -- FIXME + CAST(null AS cardinal_number) AS interval_precision, CAST(null AS sql_identifier) AS character_set_catalog, CAST(null AS sql_identifier) AS character_set_schema, @@ -937,7 +937,7 @@ CREATE VIEW domains AS AS datetime_precision, CAST(null AS character_data) AS interval_type, -- FIXME - CAST(null AS character_data) AS interval_precision, -- FIXME + CAST(null AS cardinal_number) AS interval_precision, CAST(t.typdefault AS character_data) AS domain_default, @@ -1085,7 +1085,7 @@ CREATE VIEW parameters AS CAST(null AS cardinal_number) AS numeric_scale, CAST(null AS cardinal_number) AS datetime_precision, CAST(null AS character_data) AS interval_type, - CAST(null AS character_data) AS interval_precision, + CAST(null AS cardinal_number) AS interval_precision, CAST(current_database() AS sql_identifier) AS udt_catalog, CAST(nt.nspname AS sql_identifier) AS udt_schema, CAST(t.typname AS sql_identifier) AS udt_name, @@ -1353,7 +1353,7 @@ CREATE VIEW routines AS CAST(null AS cardinal_number) AS numeric_scale, CAST(null AS cardinal_number) AS datetime_precision, CAST(null AS character_data) AS interval_type, - CAST(null AS character_data) AS interval_precision, + CAST(null AS cardinal_number) AS interval_precision, CAST(current_database() AS sql_identifier) AS type_udt_catalog, CAST(nt.nspname AS sql_identifier) AS type_udt_schema, CAST(t.typname AS sql_identifier) AS type_udt_name, @@ -1407,7 +1407,7 @@ CREATE VIEW routines AS CAST(null AS cardinal_number) AS result_cast_numeric_scale, CAST(null AS cardinal_number) AS result_cast_datetime_precision, CAST(null AS character_data) AS result_cast_interval_type, - CAST(null AS character_data) AS result_cast_interval_precision, + CAST(null AS cardinal_number) AS result_cast_interval_precision, CAST(null AS sql_identifier) AS result_cast_type_udt_catalog, CAST(null AS sql_identifier) AS result_cast_type_udt_schema, CAST(null AS sql_identifier) AS result_cast_type_udt_name, @@ -2212,7 +2212,7 @@ CREATE VIEW user_defined_types AS CAST(null AS cardinal_number) AS numeric_scale, CAST(null AS cardinal_number) AS datetime_precision, CAST(null AS character_data) AS interval_type, - CAST(null AS character_data) AS interval_precision, + CAST(null AS cardinal_number) AS interval_precision, CAST(null AS sql_identifier) AS source_dtd_identifier, CAST(null AS sql_identifier) AS ref_dtd_identifier @@ -2448,7 +2448,7 @@ CREATE VIEW element_types AS CAST(null AS cardinal_number) AS numeric_scale, CAST(null AS cardinal_number) AS datetime_precision, CAST(null AS character_data) AS interval_type, - CAST(null AS character_data) AS interval_precision, + CAST(null AS cardinal_number) AS interval_precision, CAST(null AS character_data) AS domain_default, -- XXX maybe a bug in the standard |