diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2008-11-25 20:47:42 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2008-11-25 20:47:42 +0000 |
| commit | 8a10096440eaf1f5b918aebec71c2d5ad2687fe6 (patch) | |
| tree | 082150ce7fc8771beceab3f649173098d73cadcf | |
| parent | 6bbef4e5383c99d93aa974e2c79d328cfbd1c4a9 (diff) | |
| download | postgresql-8a10096440eaf1f5b918aebec71c2d5ad2687fe6.tar.gz postgresql-8a10096440eaf1f5b918aebec71c2d5ad2687fe6.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 7289e0bd456..da01c9cc5a7 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.34 2008/09/08 00:47:40 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/information_schema.sgml,v 1.35 2008/11/25 20:47:42 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> |