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) ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])