1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
--- src.garden/grass.postgresql/g.stats.pg/infxStats.c.orig Sun Jul 11 17:20:22 2004
+++ src.garden/grass.postgresql/g.stats.pg/infxStats.c Sun Jul 11 17:20:41 2004
@@ -37,7 +37,7 @@
}
if (freq ) {
- sprintf (SQL_stmt,"SELECT count(*) as count, %s from %s %s
+ sprintf (SQL_stmt,"SELECT count(*) as count, %s from %s %s\
group by %s order by count(*)"
,col,tab,wherecl,col); }
else
@@ -48,10 +48,10 @@
PQclear (res);
if ( can_avg_col ) {
- sprintf (SQL_stmt,"SELECT min(%s) as Min, max(%s) as Max, avg(%s) as Mean
+ sprintf (SQL_stmt,"SELECT min(%s) as Min, max(%s) as Max, avg(%s) as Mean\
FROM %s %s",col,col,col,tab,wherecl); }
else
- {sprintf (SQL_stmt,"SELECT min(%s) as Min, max(%s) as Max
+ {sprintf (SQL_stmt,"SELECT min(%s) as Min, max(%s) as Max\
FROM %s %s",col,col,tab,wherecl); }
}
|
