From e32014d85de478e7baa4af9a113832ea1cd360ef Mon Sep 17 00:00:00 2001
From: Tom Lane <tgl@sss.pgh.pa.us>
Date: Fri, 19 Dec 2008 01:34:19 +0000
Subject: [PATCH] Add a couple of cross-references to the docs about enum
types, per a recent gripe that the info is hard to find.
---
doc/src/sgml/datatype.sgml | 13 ++++++++++++-
1 file changed, 12 insertions(+), 1 deletion(-)
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml
index c9669b4951..6a61c0c5bf 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>
--
2.40.0