diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2008-11-25 20:47:49 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2008-11-25 20:47:49 +0000 |
| commit | fb2a0a450b81c45f366db890bbad45dbc2616daa (patch) | |
| tree | 842816ea8e6b1b81f550645c046df26de99b2432 | |
| parent | 05798c9275261c1f9308dea5e1bee559e461b689 (diff) | |
| download | postgresql-fb2a0a450b81c45f366db890bbad45dbc2616daa.tar.gz postgresql-fb2a0a450b81c45f366db890bbad45dbc2616daa.zip | |
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.
| -rw-r--r-- | doc/src/sgml/information_schema.sgml | 14 |
1 files changed, 8 insertions, 6 deletions
diff --git a/doc/src/sgml/information_schema.sgml b/doc/src/sgml/information_schema.sgml index d4d51a34a03..c04ea28f6a7 100644 --- a/doc/src/sgml/information_schema.sgml +++ b/doc/src/sgml/information_schema.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/information_schema.sgml,v 1.33 2007/02/20 23:14:19 momjian Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/information_schema.sgml,v 1.33.2.1 2008/11/25 20:47:49 tgl Exp $ --> <chapter id="information-schema"> <title>The Information Schema</title> @@ -2192,7 +2192,7 @@ ORDER BY c.ordinal_position; <entry><type>sql_identifier</type></entry> <entry> 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) </entry> </row> @@ -2202,7 +2202,7 @@ ORDER BY c.ordinal_position; <entry><type>sql_identifier</type></entry> <entry> 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 </entry> </row> @@ -2211,7 +2211,7 @@ ORDER BY c.ordinal_position; <entry><type>sql_identifier</type></entry> <entry> Name of the table that contains the column that is restricted - by some constraint + by this constraint </entry> </row> @@ -2219,7 +2219,7 @@ ORDER BY c.ordinal_position; <entry><literal>column_name</literal></entry> <entry><type>sql_identifier</type></entry> <entry> - Name of the column that is restricted by some constraint + Name of the column that is restricted by this constraint </entry> </row> @@ -2236,7 +2236,9 @@ ORDER BY c.ordinal_position; <entry><literal>position_in_unique_constraint</literal></entry> <entry><type>cardinal_number</type></entry> <entry> - Not yet implemented + For a foreign-key constraint, ordinal position of the referenced + column within its unique constraint (count starts at 1); + otherwise null </entry> </row> </tbody> |