2 ms·
Use bigint with check-between constraint? Maybe inconvenient, but not impossible... but if this is the kind of problem you have, then, try in your favorite la
by crabbone 4y ago
Use bigint with check-between constraint?
Maybe inconvenient, but not impossible... but if this is the kind of problem you have, then, try in your favorite language to create integers that are 63 bit long or 65, and see how it goes? Looks like the comparison won't be in that language's favor.
- yencabulator 4y agoPostgres bigint is a signed 64-bit integer, not an unsigned one. https://www.postgresql.org/docs/current/datatype-numeric.html#DATATYPE-NUMERIC-TABLE 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.