Alias to a type - Mailing list pgsql-sql

From Veikko Mäkinen
Subject Alias to a type
Date
Msg-id 42B94B32.5040707@ecom.fi
Whole thread Raw
Responses Re: Alias to a type  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Re: Alias to a type  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
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>

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



pgsql-sql by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: customising serial type
Next
From: Achilleus Mantzios
Date:
Subject: Re: Alias to a type