Creating simple type aliases

From: Peter Haworth <pmh(at)edison(dot)ioppublishing(dot)com>
To: Postgres general list <pgsql-general(at)postgresql(dot)org>
Subject: Creating simple type aliases
Date: 2000-01-20 12:21:39
Message-ID: ML-3.3.948370899.5758.pmh@edison.ioppublishing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is it possible to create an alias for an existing type, so that I can refer to
it with a simple name, and possibly change it in the future? Something like:

create type-alias issn as char(9)

Without that it looks like I have to do

create type issn (
input=charin, output=charout,
internallength=9, externallength=9,
element='char'
)
then insert a row to pg_opclass, after attempting to use the new type to find
its ID.

Surely there's an easier way?

--
Peter Haworth pmh(at)edison(dot)ioppublishing(dot)com
"Never tell people how to do things.
Tell them WHAT to do and they will surprise you with their ingenuity."
-- Gen. George S. Patton, Jr.

Browse pgsql-general by date

  From Date Subject
Next Message Yury Don 2000-01-20 12:27:10 Re[3]: [GENERAL] Bug or my crooked hands?
Previous Message Peter Eisentraut 2000-01-20 11:41:22 Re: [GENERAL] apache logs to pgsql