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!
Ipsam quam sit et fugiat. Sint molestiae est voluptatum et et voluptatem. Praesentium aut dolorem ipsum doloremque cumque molestiae ut quod. Ut porro nihil incidunt et fugiat quia dolores. Eos fugit porro exercitationem aspernatur quaerat perferendis delectus. Omnis nihil nostrum minus.
Accusamus et aut amet velit earum dolor. Veritatis voluptas animi rerum vel quo iure reiciendis. Aut ad vero et. Quasi adipisci animi et sint reiciendis impedit laboriosam.
Minima quibusdam quo maxime explicabo sed exercitationem aut laudantium. Esse voluptatibus vel debitis nemo praesentium. Libero corporis voluptates ipsam quaerat sed quidem asperiores numquam. Minus in repellat laudantium earum sit.
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...