Add docs for VARINT #4669
Add docs for VARINT #4669
Conversation
Add docs for VARINT
docs/sql/data_types/numeric.md
Outdated
| | `USMALLINT` | - | 0 | 65535 | 2 | | ||
| | `UINTEGER` | - | 0 | 4294967295 | 4 | | ||
| | `UBIGINT` | - | 0 | 18446744073709551615 | 8 | | ||
| | `UHUGEINT` | - | 0 | 340282366920938463463374607431768211455 | 16 | |
There was a problem hiding this comment.
I guess we could also add VARINT here?
There was a problem hiding this comment.
I don't think that's a good idea.
The minimum and maximum are both incredibly huge, and the Size in Bytes is variable, which is exactly why I've made a separate section for it.
I do understand why it would fit there, because it is just a numeric like the others in the list, but it's giant
There was a problem hiding this comment.
Well, that's a summary, on top of the page, and most likely the only thing that 99.9% of the people will read from it, so that's why I think is important to add it there. The ranges might look "confusing" at first glance, but then readers can check the actual varint description you added, if it's not immediately clear to them.
I think for bytes you can have the range 4 - 2ˆ23 bytes. Min and max can be a value * 10^...
I can also do that in a later PR.
This PR fixes #4521
I've cherry-picked some interesting information from the PR, focusing on the storage aspect, as that's the most relevant difference between the other integer types (that and the incredibly high amount of digits of course)
Because of that, I've also added
Size in Bytesto the existing table of integer types.