From c2a4af48894b69cb3b37005998fe4d8a8fc8e446 Mon Sep 17 00:00:00 2001
From: garvinhicking <garvinhicking>
Date: Fri, 28 Oct 2005 08:03:30 +0000
Subject: [PATCH] Fix postgresql group by

---
 include/functions.inc.php | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/include/functions.inc.php b/include/functions.inc.php
index 9d1d4b6..b8db1d1 100644
--- a/include/functions.inc.php
+++ b/include/functions.inc.php
@@ -187,7 +187,8 @@ function serendipity_fetchUsers($user = '', $group = null, $is_count = false) {
     
     if ($is_count || $group != null) {
         if ($serendipity['dbType'] == 'postgres') {
-            $query_group    = '';
+            // Why does PostgreSQL keep doing this to us? :-)
+            $query_group    = 'GROUP BY a.authorid, a.realname, a.username, a.password, a.mail_comments, a.mail_trackbacks, a.email, a.userlevel, a.right_publish';
             $query_distinct = 'DISTINCT';
         } else {
             $query_group    = 'GROUP BY a.authorid';
-- 
2.39.5