Re: Alias to a type - Mailing list pgsql-sql

On Jun 22, 2005, at 7:42 AM, Achilleus Mantzios wrote:

> O Veikko Mδkinen έγραψε στις Jun 22, 2005 :
>
>> Hey,
>>
>> Is it possible to create a new type as an alias to a pre-defined
>> type? I
>> use "USERID varchar(20)" in almost every table I have I'd like to make
>> an alias for that type eg.
>>
>> <pseudo-sql>
>>    create type myschema.useridtype as varchar(20);
>> </pseudo-sql>
>>
>
> Try something like
>
> CREATE DOMAIN my_integer AS INTEGER;

Just for my own edification, does creating a "simple" domain like this
then require a whole set of functions for indexing, etc., like other
more complex user-defined types, or will postgres "do the right thing"?

Thanks,
Sean