Re: Alias to a type

O Sean Davis έγραψε στις Jun 22, 2005 :

>
> 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"?

In the above example you may safely consider indexing columns
of type my_integer as indexing INTEGERs.

>
> Thanks,
> Sean
>
>

--
-Achilleus