Re: Porting MySQL data types to PostgreSQL

From: ptjm(at)interlog(dot)com (Patrick TJ McPhee)
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Porting MySQL data types to PostgreSQL
Date: 2007-07-30 03:53:17
Message-ID: 13aqo5d7n7d5801@corp.supernews.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2007-07-30 04:54:40 == PostgreSQL Weekly News - July 29 2007 ==
Previous Message pc 2007-07-30 03:19:58 Re: query to match '\N'