Re: [SQL] Alias to a type

[Sean Davis]

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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly