News for hackers. Stuff that matters.

A comment on Why Does Everyone Run Ancient Postgres Versions?. Parent comment

Re:Why Does Everyone Run Ancient Postgres Versions? by evanelias on Saturday October 19, 2024 @04:05PM (#41890351)
This has always been possible, for example using the BINARY(16) column type if you want to be efficient. Or in MariaDB 10.7+ you can now use the dedicated UUID column type, which is equivalent to BINARY(16) under the hood, but provides a human-readable hex value when queried.

UUIDs are fixed-length. Blobs are not the appropriate type for that.

[ Parent | on HN ]
Re:Why Does Everyone Run Ancient Postgres Versions? by ComputerGuru on Wednesday October 23, 2024 @12:51AM (#41921933)
Sorry, I was mistaken and I already do have that set up and working using binary. There’s something else I’m trying but failing to remember that isn’t possible with binary keys.
[ Parent | on HN ]