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

Download this file

group_concat.transformed    13 lines (12 with data), 483 Bytes

wn0.Sampleset.createview=CREATE OR REPLACE VIEW %wn0.Sampleset.view% AS SELECT synsetid, 
###
grouped=%Sample.table%.sample
groupsort=sampleid
sep='|'
alias=sampleset
table=%Sample.table%
groupby=synsetid
###;
wn0.Sampleset.createview=CREATE OR REPLACE VIEW %wn0.Sampleset.view% AS SELECT synsetid, 
array_to_string (ARRAY (SELECT %Sample.table%.sample FROM %Sample.table% WHERE synsetid = t.synsetid ORDER BY sampleid),'|') AS sampleset 
FROM %Sample.table% AS t GROUP BY synsetid;