|
1 | | -<!-- $PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.234 2008/11/11 02:42:31 tgl Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.235 2008/12/19 01:34:19 tgl Exp $ --> |
2 | 2 |
|
3 | 3 | <chapter id="datatype"> |
4 | 4 | <title id="datatype-title">Data Types</title> |
@@ -2742,6 +2742,10 @@ SELECT * FROM test1 WHERE a; |
2742 | 2742 | <secondary>enumerated (enum)</secondary> |
2743 | 2743 | </indexterm> |
2744 | 2744 |
|
| 2745 | + <indexterm zone="datatype-enum"> |
| 2746 | + <primary>enumerated types</primary> |
| 2747 | + </indexterm> |
| 2748 | + |
2745 | 2749 | <para> |
2746 | 2750 | Enumerated (enum) types are data types that |
2747 | 2751 | are comprised of a static, predefined set of values with a |
@@ -2886,6 +2890,13 @@ SELECT person.name, holidays.num_weeks FROM person, holidays |
2886 | 2890 | Spaces in the labels are significant, too. |
2887 | 2891 | </para> |
2888 | 2892 |
|
| 2893 | + <para> |
| 2894 | + The translations from internal enum values to textual labels are |
| 2895 | + kept in the system catalog |
| 2896 | + <link linkend="catalog-pg-enum"><structname>pg_enum</structname></link>. |
| 2897 | + Querying this catalog directly can be useful. |
| 2898 | + </para> |
| 2899 | + |
2889 | 2900 | </sect2> |
2890 | 2901 | </sect1> |
2891 | 2902 |
|
|