Re: Porting MySQL data types to PostgreSQL

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Porting MySQL data types to PostgreSQL
Date: 2007-07-26 02:37:11
Message-ID: 3C78964C-939D-46C3-AFC6-2DD80B609754@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

[Please reply to the list so that others may benefit from and
participate in the discussion, and please don't top post as it makes
the discussion more difficult to follow.]

On Jul 25, 2007, at 20:55 , Gautam Sampathkumar wrote:

> Thank you for your answer. Do you know why a choice was
> made to
> not include support for unsigned in PostgreSQL?
>

If I'm reading my draft copy of the SQL:2003 standard, SQL only
specifies SMALLINT, INTEGER, and BIGINT integer types. There are no
unsigned integer types in the standard. While PostgreSQL does have
datatypes which extend the SQL standard, either no one has felt the
need for an unsigned data type or it has not been accepted by core.
You could check the mailing list archives for details if you wish.

Michael Glaesemann
grzm seespotcode net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Robby Russell 2007-07-26 04:08:56 Replicating db structure changes
Previous Message Michael Glaesemann 2007-07-26 01:51:30 Re: Porting MySQL data types to PostgreSQL