Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO document
- (id,
- title,
- abstract,
- doctype,
- repository,
- rights)
- SELECT REPLACE(REPLACE(projectid, '40|corda__h2020', '50|h2020_object'),
- '40|corda_______', '50|fp7___object') AS id,
- 'Objectives of project '
- ||( administrative_data ->> 'acronym' :: text ) AS title,
- objective ->> 'text' AS abstract,
- 'projectreport' AS doctype,
- 'EC' AS repository,
- 'OPEN' :: text AS rights
- FROM project_portfolio
- UNION ALL
- SELECT REPLACE(REPLACE(projectid, '40|corda__h2020', '50|h2020summary'),
- '40|corda_______', '50|fp7__summary') AS id,
- 'Final report summary of project '
- ||( administrative_data ->> 'acronym' :: text ) AS title,
- final_report_summary ->> 'text' AS abstract,
- 'projectreport' AS doctype,
- 'EC' AS repository,
- 'OPEN' :: text AS rights
- FROM project_portfolio
- UNION ALL
- SELECT REPLACE(REPLACE(projectid, '40|corda__h2020', '50|h2020___exec'),
- '40|corda_______', '50|fp7_____exec') AS id,
- 'Executive summary of project '
- ||( administrative_data ->> 'acronym' :: text ) AS title,
- executive_summary ->> 'text' AS abstract,
- 'projectreport' AS doctype,
- 'EC' AS repository,
- 'OPEN' :: text AS rights
- FROM project_portfolio
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement