diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2002-07-22 20:23:19 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2002-07-22 20:23:19 +0000 |
| commit | e9c013f4bddd953df03be74177a37016d1e22b96 (patch) | |
| tree | 8aa2299d3c1666eb5647c60e805aad0b6924cd9a /doc/src | |
| parent | a7ffd69d4cc38ea9ede168719caba354b3af0a99 (diff) | |
| download | postgresql-e9c013f4bddd953df03be74177a37016d1e22b96.tar.gz postgresql-e9c013f4bddd953df03be74177a37016d1e22b96.zip | |
Add unique index on pg_cast.oid, and document pg_cast table.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/catalogs.sgml | 66 |
1 files changed, 65 insertions, 1 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 602680aaacb..ccb316e3c4e 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -1,6 +1,6 @@ <!-- Documentation of the system catalogs, directed toward PostgreSQL developers - $Header: /cvsroot/pgsql/doc/src/sgml/catalogs.sgml,v 2.45 2002/07/12 18:43:12 tgl Exp $ + $Header: /cvsroot/pgsql/doc/src/sgml/catalogs.sgml,v 2.46 2002/07/22 20:23:19 petere Exp $ --> <chapter id="catalogs"> @@ -67,6 +67,11 @@ </row> <row> + <entry>pg_cast</entry> + <entry>casts (data type conversions)</entry> + </row> + + <row> <entry>pg_class</entry> <entry>tables, indexes, sequences (<quote>relations</quote>)</entry> </row> @@ -519,6 +524,65 @@ </sect1> + <sect1 id="catalog-pg-cast"> + <title>pg_cast</title> + + <para> + <structname>pg_cast</structname> stores data type conversion paths + defined with <command>CREATE CAST</command> plus the built-in + conversions. + </para> + + <table> + <title>pg_cast Columns</title> + + <tgroup cols=4> + <thead> + <row> + <entry>Name</entry> + <entry>Type</entry> + <entry>References</entry> + <entry>Description</entry> + </row> + </thead> + + <tbody> + <row> + <entry>castsource</entry> + <entry><type>oid</type></entry> + <entry>pg_type.oid</entry> + <entry>OID of the source data type</entry> + </row> + + <row> + <entry>casttarget</entry> + <entry><type>oid</type></entry> + <entry>pg_type.oid</entry> + <entry>OID of the target data type</entry> + </row> + + <row> + <entry>castfunc</entry> + <entry><type>oid</type></entry> + <entry>pg_proc.oid</entry> + <entry> + The OID of the function to use to perform this cast. A 0 is + stored if the data types are binary compatible (that is, no + function is needed to perform the cast). + </entry> + </row> + + <row> + <entry>castimplicit</entry> + <entry><type>bool</type></entry> + <entry></entry> + <entry>Indication whether this cast can be invoked implicitly</entry> + </row> + </tbody> + </tgroup> + </table> + </sect1> + <sect1 id="catalog-pg-class"> <title>pg_class</title> |