For my case that is not true as our keys are globally unique URN
strings. Thus, only the hashes may collide, but thank you for the insight.
On 2/12/26 15:47, Greg Sabino Mullane wrote:
On Thu, Feb 12, 2026 at 6:18 AM Nico Heller <[email protected]> wrote:
I just checked for hash collisions with the following query today:
SELECT COUNT(*), hashtextextended(key, 0) FROM
(
SELECT key FROM table1
UNION
FWIW, you need UNION ALL, not UNION, if you are trying to detect
duplicate values (hashed or not) across tables.
Cheers,
Greg
