Thread: Are there unsigned int types in the manual

Are there unsigned int types in the manual

From
Mike Cianflone
Date:
    Is there somewhere in the manual that specifies if there is an
unsigned int type for Postgressql. In an online manual I I see the int2,
int4, and int8 types, but they are signed. I'm looking for an unsigned 2
byte and 4 byte type that goes from 0 to 65535, and 0 to 4.2 billion,
respectively. Are they specified anywhere?

Thanks,
Mike



Re: Are there unsigned int types in the manual

From
Mark Butler
Date:
Mike Cianflone wrote:
> 
>         Is there somewhere in the manual that specifies if there is an
> unsigned int type for Postgressql. In an online manual I I see the int2,
> int4, and int8 types, but they are signed. I'm looking for an unsigned 2
> byte and 4 byte type that goes from 0 to 65535, and 0 to 4.2 billion,
> respectively. Are they specified anywhere?
> 
> Thanks,
> Mike

I am quite certain there are no such types in PostgreSQL, and that there
probably never will be.  Internally, Postgres uses an NxN type conversion
system that makes it difficult to add new primitive data types. 
- Mark Butler