aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2008-12-19 01:34:19 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2008-12-19 01:34:19 +0000
commite32014d85de478e7baa4af9a113832ea1cd360ef (patch)
tree44ba249e26fb1d85548e6df679e7b71ef53ba784
parent382af3a95406c1ee9a4a5647eb7586d1432196e3 (diff)
downloadpostgresql-e32014d85de478e7baa4af9a113832ea1cd360ef.tar.gz
postgresql-e32014d85de478e7baa4af9a113832ea1cd360ef.zip
Add a couple of cross-references to the docs about enum types, per a
recent gripe that the info is hard to find.
-rw-r--r--doc/src/sgml/datatype.sgml13
1 files changed, 12 insertions, 1 deletions
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml
index c9669b49512..6a61c0c5bf5 100644
--- a/doc/src/sgml/datatype.sgml
+++ b/doc/src/sgml/datatype.sgml
@@ -1,4 +1,4 @@
-<!-- $PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.234 2008/11/11 02:42:31 tgl Exp $ -->
+<!-- $PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.235 2008/12/19 01:34:19 tgl Exp $ -->
<chapter id="datatype">
<title id="datatype-title">Data Types</title>
@@ -2742,6 +2742,10 @@ SELECT * FROM test1 WHERE a;
<secondary>enumerated (enum)</secondary>
</indexterm>
+ <indexterm zone="datatype-enum">
+ <primary>enumerated types</primary>
+ </indexterm>
+
<para>
Enumerated (enum) types are data types that
are comprised of a static, predefined set of values with a
@@ -2886,6 +2890,13 @@ SELECT person.name, holidays.num_weeks FROM person, holidays
Spaces in the labels are significant, too.
</para>
+ <para>
+ The translations from internal enum values to textual labels are
+ kept in the system catalog
+ <link linkend="catalog-pg-enum"><structname>pg_enum</structname></link>.
+ Querying this catalog directly can be useful.
+ </para>
+
</sect2>
</sect1>