Revision 52191
Added by Claudio Atzori over 5 years ago
| materialised_views.sql | ||
|---|---|---|
| 229 | 229 |
pac.code || '@@@' || pac.name || '@@@' || pas.code || '@@@' || pas.name AS provenanceaction, |
| 230 | 230 |
array_agg(DISTINCT i.pid || '###' || i.issuertypeclass) AS pid, |
| 231 | 231 |
array_agg(DISTINCT s.name || '###' || sc.code || '@@@' || sc.name || '@@@' || ss.code || '@@@' || ss.name) AS subjects, |
| 232 |
array_agg(fp.path) AS fundingtree
|
|
| 232 |
array_agg(DISTINCT fp.path) AS fundingtree
|
|
| 233 | 233 |
FROM projects p |
| 234 | 234 |
LEFT OUTER JOIN class cc ON (cc.code = p.contracttypeclass) |
| 235 | 235 |
LEFT OUTER JOIN scheme cs ON (cs.code = p.contracttypescheme) |
Also available in: Unified diff
distinct fundingpaths in projects_mv