[667a13]: generate / run / group_concat.sql  Maximize  Restore  History

Download this file

40 lines (30 with data), 1.3 kB

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
#wn0.Sampleset.createview
synsetid,
GROUP_CONCAT (DISTINCT MYTABLE.sample ORDER BY sampleid SEPARATOR '|' ) AS sampleset
FROM MYTABLE
GROUP BY synsetid
#wn0.Sampleset.createview
t.synsetid,
array_to_string (ARRAY (SELECT sample FROM MYTABLE WHERE synsetid = t.synsetid ORDER BY sampleid),'|') AS sampleset
FROM MYTABLE AS t
GROUP BY s.synsetid
#vn0.VnExampleSets.createview
frameid,
GROUP_CONCAT (example ORDER BY exampleid ASC separator '|') AS exampleset
FROM %VnExampleMap.table% INNER JOIN %VnExample.table% USING (exampleid)
GROUP BY frameid;
#vn0.VnExampleSets.createview
s.frameid,
array_to_string (ARRAY (SELECT example FROM %VnExample.table% JOIN %VnExampleMap.table% USING (exampleid) WHERE frameid = s.frameid ORDER BY exampleid),'|'::text) AS sampleset
FROM %VnExampleMap.table% AS s
GROUP BY frameid;
#sumo0.SUMOTaggedTerm.createview=
sumoid,sumoterm,
GROUP_CONCAT (sumoattr ORDER BY sumoattr SEPARATOR '') AS attrtag
FROM %SUMOTerm.table% INNER JOIN %SUMOTermAttr.table% USING (sumoid)
GROUP BY sumoid;
#sumo0.SUMOTaggedTerm.createview=
s.sumoid,s.sumoterm,
array_to_string (ARRAY (SELECT sumoattr FROM %SUMOTermAttr.table% WHERE sumoid = s.sumoid ORDER BY sumoattr),'') AS attrtag
FROM %SUMOTerm.table% AS s INNER JOIN %SUMOTermAttr.table% USING (sumoid)
GROUP BY s.sumoid,s.sumoterm;

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks