Serial limits on postgres
I have a question about the limits of the smallserial type on postgres, as I read in the official docs, the limits of an smallinteger comes from -32768 to 32767 using a storage of 2 bytes.
But the limits of the smallserial comes from 1 to 32767 using the same 2 bytes.
My question is, if both are using the same 2 bytes, and smallserial uses only positive numbers, why it has the same upper limit than smallinteger?
Postgres docs about numbers
So, for me the most logic way of doing this is adding more positive limit to the serial type.
I'm missing something but I don't know what it is.
Can you help me? Thank you very much!
Et sapiente et consequatur est facilis. Iure esse perspiciatis dolorum neque temporibus sequi. Nobis omnis eum non quisquam praesentium illo molestias nisi.
Repellendus minus corrupti totam provident qui unde quidem. Cupiditate omnis voluptates nulla consequuntur nesciunt. Amet non et rerum est illum dolore. Sunt corrupti placeat magni vel dolor pariatur aut iure.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...