ocaml 3.09 transition

[helm.git] / helm / metadata / sql / fill_inconcl_aux.sql

diff --git a/helm/metadata/sql/fill_inconcl_aux.sql b/helm/metadata/sql/fill_inconcl_aux.sql
index 55c388462f8e1db74d3a4d9d63d50b4c6b173641..50146e0fd5d42642f512894b7000ff8fd87fead6 100644 (file)
--- a/helm/metadata/sql/fill_inconcl_aux.sql
+++ b/helm/metadata/sql/fill_inconcl_aux.sql
@@ -1,3 +1,10 @@
 
+-- table mapping sources to number of distinct constants occurring in conclusion
+INSERT INTO no_inconcl_aux
+SELECT source, COUNT(h_occurrence)
+FROM refObj
+WHERE
+  h_position='http://www.cs.unibo.it/helm/schemas/schema-helm#InConclusion'
+  OR h_position='http://www.cs.unibo.it/helm/schemas/schema-helm#MainConclusion'
+GROUP BY source;
 
- insert into no_inconcl_aux select source,count(h_occurrence) from refObj where h_position='http://www.cs.unibo.it/helm/schemas/schema-helm#InConclusion' or h_position='http://www.cs.unibo.it/helm/schemas/schema-helm#MainConclusion' group by source;