Revision 57268
Added by Claudio Atzori over 4 years ago
| materialised_views.sql | ||
|---|---|---|
| 5 | 5 |
p.id AS projectid, |
| 6 | 6 |
p.acronym AS acronym, |
| 7 | 7 |
p.code AS code, |
| 8 |
p.optional1 AS optional1, |
|
| 9 |
p.optional2 AS optional2, |
|
| 10 | 8 |
p.jsonextrainfo AS jsonextrainfo, |
| 11 | 9 |
array_agg(fp.path) AS fundingpath |
| 12 | 10 |
FROM projects p |
Also available in: Unified diff
removed optional2 and optional2 from project_details table