Re: Porting MySQL data types to PostgreSQL

[ptjm(at)interlog(dot)com (Patrick TJ McPhee)]

In article <B396176E-A0FC-43CF-8C67-38CB1AF6A520(at)decibel(dot)org>,
Jim Nasby <decibel(at)decibel(dot)org> wrote:
% On Jul 26, 2007, at 11:06 AM, Jeff Davis wrote:
% > If you really do need an unsigned type, this is a good use of
% > postgresql's extensible type system. You can just create an unsigned
% > type for yourself.
% 
% If you do that please start a project on pgfoundry so others can  
% contribute and benefit. In fact, if you do start one let me know and  
% I'll try and help out.

One problem with this idea is the treatment of implicit casts between
numeric types in TypeCategory(). For implicit casts to work, the type's
OID has to be listed in that function (i.e., it has to be a built-in type).
-- 

Patrick TJ McPhee
North York  Canada
ptjm(at)interlog(dot)com