On 2018-08-24 11:58 PM, Thomas Kurz wrote:
What is the value of a built-in UNSIGNED type when we already have INTEGER? I
can't think of any. -- Darren Duncan
Signed integers only allow half the range of values of unsigned ones. You
cannot store a pointer value in them. (You can by casting to signed, but then
sorting is done wrong.)
I fully agree with what others have said, which is that this use case is better
handled by supporting an unlimited precision integer type. All the "unsigned"
request argues for is a single extra bit of precision for positive integers,
which is like nit-picking; in practice if you can't fit all the integers you
care about in a typical signed machine integer then the unlimited type is the
only reasonable step up, for practical purposes. -- Darren Duncan
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
