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!
Necessitatibus pariatur est et. Ullam enim adipisci molestiae id quas. Laboriosam est nam vero ipsum possimus. Qui porro possimus qui. Et ex veniam aut aut qui accusamus sed magnam. Assumenda aut eum blanditiis et inventore.
Sed doloremque quia tempora. Saepe aut omnis molestiae maxime dolorem cupiditate qui. Accusantium ducimus voluptas earum dolorum minus consequatur.
Est dolores laborum consectetur laudantium quas praesentium quasi. Numquam explicabo illum sed iusto molestiae et doloremque. Occaecati earum tempora tenetur dolore tempora. Qui ullam et error beatae atque. Quo inventore quis ut ullam qui aut.
Omnis amet culpa saepe distinctio distinctio. Commodi sit minima in voluptate dolor voluptas. Amet veniam et vel omnis. Qui quod molestiae voluptatibus incidunt deleniti totam voluptatem. Est ut ut qui at saepe magni occaecati. Voluptas velit rerum adipisci expedita iste.
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...