[geeklog-hg] geeklog: fixed GROUP BY for Postgres

[geeklog-cvs at lists.geeklog.net]

changeset 8744:24e7468ba175
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/24e7468ba175
user: Dirk Haun <dirk at haun-online.de>
date: Sat Jun 30 13:20:38 2012 +0200
description:
fixed GROUP BY for Postgres

diffstat:

 system/classes/search.class.php |  2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diffs (12 lines):

diff -r aab665d998ef -r 24e7468ba175 system/classes/search.class.php
--- a/system/classes/search.class.php	Sat Jun 30 13:05:59 2012 +0200
+++ b/system/classes/search.class.php	Sat Jun 30 13:20:38 2012 +0200
@@ -357,7 +357,7 @@
         $sql .= $search_s->getDateRangeSQL('AND', 'date', $this->_dateStart, $this->_dateEnd);
         list($sql, $ftsql) = $search_s->buildSearchSQL($this->_keyType, $query, $columns, $sql);
 
-        $sql .= " GROUP BY id";
+        $sql .= " GROUP BY s.sid";
         
         $search_s->setSQL($sql);
         $search_s->setFTSQL($ftsql);