Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE VIEW metabib.record_attr AS
- SELECT v.source AS id,
- hstore(array_agg(m.attr), array_agg(m.value)) AS attrs
- FROM metabib.full_attr_id_map m
- JOIN metabib.record_attr_vector_list v ON m.id = ANY (v.vlist)
- GROUP BY v.source;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement