Thread: CREATE TYPE with two args

CREATE TYPE with two args

From
"Ameen - Etemady"
Date:
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"));

how 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







Re: CREATE TYPE with two args

From
Peter Eisentraut
Date:
Ameen - Etemady wrote:
> I want to create a data type that have tow arguments in the
> defenition, like the varchar type:

This is not possible.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/