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!
Corporis consequuntur modi voluptas nesciunt aliquam qui. Praesentium sed consequatur ipsum et enim quis. Rerum esse nihil eum quo et et quia.
Consequuntur sit tempore vero doloremque voluptatem iusto provident. Esse et voluptatem ut dolores. Laboriosam repellat ut est nostrum assumenda magnam. Velit voluptatem nam at sunt ut. Debitis porro dolor voluptatem nulla nostrum sit. Veritatis optio perspiciatis quo sunt ea. Veniam iste reprehenderit consequuntur quis suscipit veniam et.
Dolores provident et laborum quidem ratione aliquid sint. Mollitia est repellat explicabo sapiente ea odit.
Fuga ipsam quia officiis quidem. Ut voluptatem dolores aut quas voluptas amet voluptatem et. Beatae tempora expedita nam est. Eum nobis fugit amet aut sit voluptatem sint id.
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...