Revision 52192
Added by Claudio Atzori almost 6 years ago
materialised_views.sql | ||
---|---|---|
217 | 217 |
pac.code || '@@@' || pac.name || '@@@' || pas.code || '@@@' || pas.name AS provenanceaction, |
218 | 218 |
array_agg(DISTINCT i.pid || '###' || i.issuertypeclass) AS pid, |
219 | 219 |
array_agg(DISTINCT s.name || '###' || sc.code || '@@@' || sc.name || '@@@' || ss.code || '@@@' || ss.name) AS subjects, |
220 |
array_agg(fp.path) AS fundingtree
|
|
220 |
array_agg(DISTINCT fp.path) AS fundingtree
|
|
221 | 221 |
FROM projects p |
222 | 222 |
LEFT OUTER JOIN class cc ON (cc.code = p.contracttypeclass) |
223 | 223 |
LEFT OUTER JOIN scheme cs ON (cs.code = p.contracttypescheme) |
Also available in: Unified diff
distinct fundingpaths in projects_mv