aliasing and/or defining types - Mailing list pgsql-novice

From Matt Clark
Subject aliasing and/or defining types
Date
Msg-id 200303271952.h2RJqqS22191@rushe.aero.org
Whole thread Raw
List pgsql-novice
Is there a simple way to create a type, which is a derived from an existing
type?

I need something like

create type newID as numeric(16,0);

create table xx (tid newID,.....);

I have existing SQL, with several types defined as above.
I hope not to have to edit all occurrences of "newID".......

Note that it's not a composite type, but just an instance of an existing type.

Thanks,

Matt


pgsql-novice by date:

Previous
From: Ennio-Sr
Date:
Subject: Extended display and extended ascii characters
Next
From: Vittorio Zuccala'
Date:
Subject: Re: get the oid