X-Git-Url: http://git.cyclocoop.org/?p=ptitvelo%2Fweb%2Fwww.git;a=blobdiff_plain;f=www%2Fecrire%2Freq%2Fpg.php;fp=www%2Fecrire%2Freq%2Fpg.php;h=e4cad0edd219294a32720498247f225c0d9b30d3;hp=57d23e1186b243c2c47a5fa5f1842eb94606cae9;hb=b97874b04ea8ca43d21b7ef7309feff8ef0e4a07;hpb=92c7d7f7bccb9629bb7c81b9582b56b61c3f8ec9

diff --git a/www/ecrire/req/pg.php b/www/ecrire/req/pg.php
index 57d23e1..e4cad0e 100644
--- a/www/ecrire/req/pg.php
+++ b/www/ecrire/req/pg.php
@@ -574,6 +574,10 @@ function spip_pg_groupby($groupby, $from, $select)
 	if (!$groupby) return '';
 
 	$groupby = spip_pg_frommysql($groupby);
+	// Ne pas mettre dans le Group-By des valeurs numeriques
+	// issue de prepare_recherche
+	$groupby = preg_replace('/^\s*\d+\s+AS\s+\w+\s*,?\s*/i','', $groupby);
+	$groupby = preg_replace('/,\s*\d+\s+AS\s+\w+\s*/i','', $groupby);
 	$groupby = preg_replace('/\s+AS\s+\w+\s*/i','', $groupby);
 
 	return "\nGROUP BY $groupby";