Message-ID: <34544.62.220.101.165.1099497388.squirrel@ce.sharif.edu>
Date: Wed, 3 Nov 2004 19:26:28 +0330 (IRST)
Subject: CREATE TYPE
From: "Ameen  - Etemady" <eetemadi@ce.sharif.edu>
To: pgsql-sql@postgresql.org
User-Agent: SquirrelMail/1.4.2
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Importance: Normal
X-sina.sharif.edu-MailScanner-Information: Please contact the ISP for more
	information
X-sina.sharif.edu-MailScanner: Found to be clean
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.4 tagged_above=0.0 required=5.0
	tests=PRIORITY_NO_NAME, SUBJ_ALL_CAPS
X-Spam-Level: *
X-Archive-Number: 200411/28
X-Sequence-Number: 19347

I want to create a data type that have tow arguments in the defenition,
like the varchar type:
create table mytmp(name varchar(10));

I like to do it like this:
create table mytmp(name myvarchar(10,"en_US"));

whow can it be done by "CREATE TYPE"
I want to implement the internal functions (compare, ...).
I faunded the documentation but I can't see any thing that help me to
create a type same as varchar( with argument)

Notice: I don't mean using "CREATE TYPE myvarchar AS( lenght integer,
collate char(10))

Thanks