From e32014d85de478e7baa4af9a113832ea1cd360ef Mon Sep 17 00:00:00 2001 From: Tom Lane 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 @@ - + Data Types @@ -2742,6 +2742,10 @@ SELECT * FROM test1 WHERE a; enumerated (enum) + + enumerated types + + 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. + + The translations from internal enum values to textual labels are + kept in the system catalog + pg_enum. + Querying this catalog directly can be useful. + + -- 2.40.0