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

Reply via email to