News for hackers. Stuff that matters.
Re:Oops, You Wrote a Database by yencabulator on Monday February 27, 2023 @02:40PM (#34960918)
Postgres bigint is a signed 64-bit integer, not an unsigned one. https://www.postgresql.org/docs/current/datatype-numeric.htm...

Trying to use it to store the full range of unsigned values would mean awkward math everywhere, to convert between the two ranges.

Lots of software uses uint64s, for e.g. as identifiers handed out by some API, and not being able to store them conveniently definitely hurts.

There are no comments on this comment yet.