From fffe0b039ab452295953c9d30956bf24ce2fef63 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Tue, 25 Nov 2008 20:47:55 +0000 Subject: [PATCH] information_schema.key_column_usage.position_in_unique_constraint was misdocumented as not being implemented. In reality it has worked since the release of 8.2. --- doc/src/sgml/information_schema.sgml | 12 +++++++----- 1 file changed, 7 insertions(+), 5 deletions(-) diff --git a/doc/src/sgml/information_schema.sgml b/doc/src/sgml/information_schema.sgml index 62ce85ae71..a4af2aea56 100644 --- a/doc/src/sgml/information_schema.sgml +++ b/doc/src/sgml/information_schema.sgml @@ -2192,7 +2192,7 @@ ORDER BY c.ordinal_position; sql_identifier Name of the database that contains the table that contains the - column that is restricted by some constraint (always the + column that is restricted by this constraint (always the current database) @@ -2202,7 +2202,7 @@ ORDER BY c.ordinal_position; sql_identifier Name of the schema that contains the table that contains the - column that is restricted by some constraint + column that is restricted by this constraint @@ -2211,7 +2211,7 @@ ORDER BY c.ordinal_position; sql_identifier Name of the table that contains the column that is restricted - by some constraint + by this constraint @@ -2219,7 +2219,7 @@ ORDER BY c.ordinal_position; column_name sql_identifier - Name of the column that is restricted by some constraint + Name of the column that is restricted by this constraint @@ -2236,7 +2236,9 @@ ORDER BY c.ordinal_position; position_in_unique_constraint cardinal_number - Not yet implemented + For a foreign-key constraint, ordinal position of the referenced + column within its unique constraint (count starts at 1); + otherwise null -- 2.39.5