I wish Postgres would just allow you look up records by the random component of the field, what are the chances of collisions with 80 bits of randomness? My guess is it’s still enough.

▲

jagged-chisel a day ago | parent | next [-]

You can certainly create that index.

	▲	andy_ppp a day ago \| parent [-]
		Yes, just obviously if it’s automated and part of Postgres people will use it without having to think too much and it removes one of the objections to what I think for most large systems is a sensible way to go rather than controversial because security.

▲

mamcx a day ago | parent | prev [-]

What could be better is to allow to create a type with custom display, in/out and internally set the native type IN SQL (this require to do it in c)