On 05/29/2013 11:33 AM, Maciej Gajewski wrote: > I will implement it as an extension then. > > My feeling is that PostgreSQL extensions tend to fall into obscurity. > As an ordinary user it took me really long time to find out that > interesting features are available in form of extensions; they are > certainly under-marketed. But this is a topic for separate discussion. > >> You have not at all addressed the real problem with doing what you are >> asking for, the one that Tom Lane stated: > >>> Basically, there is zero chance this will happen unless you can find >>> a way of fitting them into the numeric promotion hierarchy that doesn't >>> break a lot of existing applications. We have looked at this more than >>> once, if memory serves, and failed to come up with a workable design >>> that didn't seem to violate the POLA. >>> > I'm sorry, I thought my proposal was clear. > > I propose to not integrate the unsigned types into existing promotion > hierarchy, and behave just like gcc would with -Werror: require > explicit cast. Between them, the unsigned types would be automatically > converted up (uint2 > uint4 > uint8). +1
(And we could even put some possible sample cast sets in contrib for those who need automatic casts and are willing to do the required debugging ) -- Hannu Krosing PostgreSQL Consultant Performance, Scalability and High Availability 2ndQuadrant Nordic OÜ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers