diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2011-04-17 17:05:51 -0400 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2011-04-17 17:05:51 -0400 |
commit | 2d4617126f6d708c5777b378d9ef282fb2c08930 (patch) | |
tree | 79b0e1974ca784a29ca44c8af0f01668c9337168 | |
parent | acfa1f45ed3ee2144581954c77769056bd149f5c (diff) | |
download | postgresql-2d4617126f6d708c5777b378d9ef282fb2c08930.tar.gz postgresql-2d4617126f6d708c5777b378d9ef282fb2c08930.zip |
Document COLLATE option in CREATE TYPE reference page.
Curiously, it was already documented in ALTER TYPE ADD ATTRIBUTE, but
not here.
-rw-r--r-- | doc/src/sgml/ref/create_type.sgml | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/doc/src/sgml/ref/create_type.sgml b/doc/src/sgml/ref/create_type.sgml index f5527d8981b..98e1764b1e9 100644 --- a/doc/src/sgml/ref/create_type.sgml +++ b/doc/src/sgml/ref/create_type.sgml @@ -22,7 +22,7 @@ PostgreSQL documentation <refsynopsisdiv> <synopsis> CREATE TYPE <replaceable class="parameter">name</replaceable> AS - ( [ <replaceable class="PARAMETER">attribute_name</replaceable> <replaceable class="PARAMETER">data_type</replaceable> [, ... ] ] ) + ( [ <replaceable class="PARAMETER">attribute_name</replaceable> <replaceable class="PARAMETER">data_type</replaceable> [ COLLATE <replaceable>collation</replaceable> ] [, ... ] ] ) CREATE TYPE <replaceable class="parameter">name</replaceable> AS ENUM ( [ '<replaceable class="parameter">label</replaceable>' [, ... ] ] ) @@ -77,11 +77,12 @@ CREATE TYPE <replaceable class="parameter">name</replaceable> The first form of <command>CREATE TYPE</command> creates a composite type. The composite type is specified by a list of attribute names and data types. - This is essentially the same as the row type + An attribute's collation can be specified too, if its data type is + collatable. A composite type is essentially the same as the row type of a table, but using <command>CREATE TYPE</command> avoids the need to create an actual table when all that is wanted is to define a type. - A stand-alone composite type is useful as the argument or return type of a - function. + A stand-alone composite type is useful, for example, as the argument or + return type of a function. </para> </refsect2> |