Advertisement
Guest User

Untitled

a guest
Jan 30th, 2019
159
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 1.79 KB | None | 0 0
  1. INSERT INTO document
  2.             (id,
  3.              title,
  4.              abstract,
  5.              doctype,
  6.              repository,
  7.              rights)
  8. SELECT REPLACE(REPLACE(projectid, '40|corda__h2020', '50|h2020_object'),
  9.               '40|corda_______', '50|fp7___object')    AS id,
  10.        'Objectives of project '
  11.        ||( administrative_data ->> 'acronym' :: text ) AS title,
  12.        objective ->> 'text'                            AS abstract,
  13.        'projectreport'                                 AS doctype,
  14.        'EC'                                            AS repository,
  15.        'OPEN' :: text                                  AS rights
  16. FROM   project_portfolio
  17. UNION ALL
  18. SELECT REPLACE(REPLACE(projectid, '40|corda__h2020', '50|h2020summary'),
  19.               '40|corda_______', '50|fp7__summary')    AS id,
  20.        'Final report summary of project '
  21.        ||( administrative_data ->> 'acronym' :: text ) AS title,
  22.        final_report_summary ->> 'text'                 AS abstract,
  23.        'projectreport'                                 AS doctype,
  24.        'EC'                                            AS repository,
  25.        'OPEN' :: text                                  AS rights
  26. FROM   project_portfolio
  27. UNION ALL
  28. SELECT REPLACE(REPLACE(projectid, '40|corda__h2020', '50|h2020___exec'),
  29.               '40|corda_______', '50|fp7_____exec')    AS id,
  30.        'Executive summary of project '
  31.        ||( administrative_data ->> 'acronym' :: text ) AS title,
  32.        executive_summary ->> 'text'                    AS abstract,
  33.        'projectreport'                                 AS doctype,
  34.        'EC'                                            AS repository,
  35.        'OPEN' :: text                                  AS rights
  36. FROM   project_portfolio
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement