Re: [LONGINT] Problem

On Thu, 25 Oct 2001, Alexey Prohorenko wrote:

>     I am new to PostgreSQL -- (I am migrating from MySQL), so I have
>     some, may be "stupid", but still interesting questions. 
>     Interesting for me. :-)
> 
>     In MySQL there was type called INT UNSIGNED, where I used
>     to keep values from 1 to 4294967295 without any problems.
>     1 is '00000000000000000000000000000001' in binary, and
>     4294967295 is '11111111111111111111111111111111'.
> 
>     I also was able to do f.e. 'SELECT xxx WHERE (xxx & 2147483648)'
>     and get everything I want.
>     2147483648 is '10000000000000000000000000000000' in binary.
> 
>     Nevertheless, with PostgreSQL I have troubles. I didn't find
>     any type which will help me to do everything above mentioned.
> 
>     May be someone of you was in the same situation, or has enough
>     knowledge to help me with that?

I think all of the postgres types are signed. An int8 will store the
values (at the cost of alot of extra bits).  I think if you were
willing to do a little coding you'd probably be able to make a 
uint4 type (but I don't know what'd be involved in actually doing that)