Author: tille
Date: Wed Jan 26 11:13:01 2011
New Revision: 2623
URL: http://svn.debian.org/wsvn/blends/?sc=1&rev=2623
Log:
Do not maintain several versions of the same function in separate files
Removed:
blends/trunk/team_analysis_tools/archives_02.sql
blends/trunk/team_analysis_tools/archives_03.sql
Modified:
blends/trunk/team_analysis_tools/archives_01.sql
Modified: blends/trunk/team_analysis_tools/archives_01.sql
URL:
http://svn.debian.org/wsvn/blends/blends/trunk/team_analysis_tools/archives_01.sql?rev=2623&op=diff
==============================================================================
--- blends/trunk/team_analysis_tools/archives_01.sql (original)
+++ blends/trunk/team_analysis_tools/archives_01.sql Wed Jan 26 11:13:01 2011
@@ -165,7 +165,7 @@
ret := ''SELECT EXTRACT(''''year'''' FROM year) AS year'' ;
FOR r1 IN EXECUTE query1 LOOP
- ret := ret || '', CAST(SUM("'' || r1.feature || ''") AS int) AS "'' ||
r1.feature || ''"'' ;
+ ret := ret || '', CAST(SUM("'' || r1.feature || ''") AS int) AS "'' ||
replace(r1.feature,'' '',''_'') || ''"'' ;
END LOOP;
ret := ret || ''
@@ -187,7 +187,7 @@
END LOOP ;
ret := ret || ''
FROM listarchive
- WHERE '' || Feature || '' = '''''' || replace(r1.feature, '''''''',
'''''''''''') || '''''' GROUP BY year''; -- There are names containing
apostrophs ...
+ WHERE '' || Feature || '' = '''''' || replace(r1.feature, '''''''',
'''''''''''') || '''''' GROUP BY year'';
END LOOP ;
ret := ret || ''
_______________________________________________
Blends-commit mailing list
[email protected]
http://lists.alioth.debian.org/mailman/listinfo/blends-commit
