CSN <cool_screen_name90001@xxxxxxxxx> writes: > If integer's range is -2147483648 to +2147483647, why > is serial's range only 1 to 2147483647 instead of 1 to > about 4294967294? How are you going to stuff 4294967294 into an integer field, which as you just stated has an upper limit of 2147483647? If we had an unsigned int type, we could use it for serial and get that result, but we do not. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend