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

From Achilleus Mantzios
Subject Re: Alias to a type
Date
Msg-id Pine.LNX.4.44.0506221513250.4986-100000@matrix.gatewaynet.com
Whole thread Raw
In response to Re: Alias to a type  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Alias to a type
Next
From: Veikko Mäkinen
Date:
Subject: Re: Alias to a type