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

From Dennis Gearon
Subject Re: How can I get a column INT4 to be UNSIGNED ?
Date
Msg-id 3E972F15.2080803@cvc.net
Whole thread Raw
In response to Re: How can I get a column INT4 to be UNSIGNED ?  (Kyle <kyle@ccidomain.com>)
Responses Re: How can I get a column INT4 to be UNSIGNED ?  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
If he wants the full range of an INT4 unsigned,  he needs to go to INT8 with the
constraint you mentioned. The underlying col type of INT4 only supports HALF of
the range of an INT4 unsigned, in the positive domain, that is.

Kyle wrote:
>  > Is there a reason for not supporting unsigned types?
>
> Maybe I'm off base here, but couldn't you put in a constraint to achieve
> the same effect?  In other words require inserted data in that column to
> be > -1 ?
>
> -Kyle
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>


pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: Re: pg_dump: NOTICE: ShmemAlloc: out of memory
Next
From: Dennis Gearon
Date:
Subject: Re: Case sensitive order by