Just noticed I was appearing twice in the participant list because I was a teacher and a student in the same course.

Adding a "GROUP BY u.id" works on MySQL, eg something like the code below, but I suspect it might have some problems on PostgreSQL, even though looking at the data it SEEMS that all the data in the rows are identical.

Index: user/index.php
===================================================================
RCS file: /cvsroot/moodle/moodle/user/index.php,v
retrieving revision 1.190
diff -c -r1.190 index.php

• • • user/index.php 20 Sep 2007 05:54:32 -0000 1.190
    • user/index.php 21 Sep 2007 06:48:25 -0000
      ***************
    • 383,389 ****
      }

if ($table->get_sql_sort())

{ ! $sort = ' ORDER BY '.$table->get_sql_sort(); }

else

{ $sort = ''; }
— 383,389 ----
}

if ($table->get_sql_sort()) { ! $sort = 'GROUP BY u.id ORDER BY '.$table->get_sql_sort(); } else { $sort = ''; }