drop view erec_view ;

create view erec_view as
select num||'/title' as id, title as content from open_positions
union
select num||'/department', department from open_positions
union
select num||'/description', description from open_positions
union
select num||'/edu_req', edu_req from open_positions
union
select num||'/qual_req', qual_req from open_positions
union
select num||'/others', others from open_positions
;
