Re: Alias to a type

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;

> I might have to alter the type some day and this way I'd have to just 
> re-define the alias. Can this be achieved by creating a new type with 
> CREATE TYPE? What are the input/output functions in the CREATE TYPE 
> definition?
> 
> Thanks.
> 
> 
> -veikko
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
>                http://archives.postgresql.org
> 

-- 
-Achilleus