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.
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 |