Advertisement
Guest User

Untitled

a guest
Apr 10th, 2014
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE OR REPLACE VIEW metabib.record_attr AS
  2.   SELECT v.source AS id,
  3.     hstore(array_agg(m.attr), array_agg(m.value)) AS attrs
  4.    FROM metabib.full_attr_id_map m
  5.    JOIN metabib.record_attr_vector_list v ON m.id = ANY (v.vlist)
  6.   GROUP BY v.source;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement