aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2011-04-17 17:05:51 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2011-04-17 17:05:51 -0400
commit2d4617126f6d708c5777b378d9ef282fb2c08930 (patch)
tree79b0e1974ca784a29ca44c8af0f01668c9337168
parentacfa1f45ed3ee2144581954c77769056bd149f5c (diff)
downloadpostgresql-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.sgml9
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>