Postgres Pro
Downloads
Home   >   mailing lists

Re: How can I get a column INT4 to be UNSIGNED ? - Mailing list pgsql-general

From Tom Lane
Subject Re: How can I get a column INT4 to be UNSIGNED ?
Date
Msg-id 11204.1050069949@sss.pgh.pa.us
Whole thread Raw
In response to How can I get a column INT4 to be UNSIGNED ?  ("Bruno Baguette" <bruno.baguette@netcourrier.com>)
Responses Re: How can I get a column INT4 to be UNSIGNED ?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
Tree view 
"Bruno Baguette" <bruno.baguette@netcourrier.com> writes:
> So, is it possible to create a column with an UNSIGNED INT4 type ?

No.

You could use OID, which just happens to be 4 bytes unsigned.  But a
cleaner approach IMHO would be to use int8 and put a CHECK constraint
on it to limit the range of values.

            regards, tom lane

pgsql-general by date:

Previous
From: "Thomas Mammen"
Date:
Subject: help Request
Next
From: Shridhar Daithankar
Date:
Subject: Re: help Request