From: | Stephen Frost <sfrost(at)snowman(dot)net> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Compatibility types, type aliases, and distinct types |
Date: | 2008-08-18 12:33:44 |
Message-ID: | 20080818123344.GF16005@tamriel.snowman.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
* Peter Eisentraut (peter_e(at)gmx(dot)net) wrote:
> There is also another possible way one might want to create a compatibility
> type. Instead of creating a new type, create an alias for an existing type,
> much like we currently have built-in mappings for int -> int4, bigint ->
> int8, etc. The difference here is that the type you put in is not the same
> as the one you get dumped out. So depending on taste and requirements, a
> user might want to choose the distinct type or the alias route.
The alias route gets me thinking about Oracle synonyms.. That'd be nice
to have in PG for a number of object types. Most recently I was wishing
I could create a schema synonym, though being able to do tables/views
would have worked as well in that case, just a bit more work.
> What do you think about adding this kind of support to PostgreSQL? Obviously,
> some details need to be worked out, but most of this is actually
> straightforward catalog manipulation.
I like the concept. Not sure how much I'd end up using it, personally.
Thanks,
Stephen
From | Date | Subject | |
---|---|---|---|
Next Message | Asko Oja | 2008-08-18 12:50:29 | Re: Compatibility types, type aliases, and distinct types |
Previous Message | Oleg Bartunov | 2008-08-18 12:22:45 | Re: any psql static binary for iphone ? |