bigint

MySQL BETWEEN on unsigned bigint

I'm working on a rails app that has an IPv6 model. I'm storing the IPv6 address in 2 32-bit ints and a 64-bit int: +-----------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+---------------------+...

Bigint on PostgreSQL 8.3

I have a users table with a primary key uid of data type bigint. I don't understand why I get the error : "Minteger out of range" when trying to add a user with uid = 100000349053153. This should work (according to the doc: http://www.postgresql.org/docs/8.3/static/datatype.html) ...