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

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
>