Re: How can I get a column INT4 to be UNSIGNED ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Bruno Baguette" <bruno(dot)baguette(at)netcourrier(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How can I get a column INT4 to be UNSIGNED ?
Date: 2003-04-11 14:05:49
Message-ID: 11204.1050069949@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Bruno Baguette" <bruno(dot)baguette(at)netcourrier(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2003-04-11 14:11:44 Re: help Request
Previous Message Thomas Mammen 2003-04-11 13:59:42 help Request