LP1615805 No inputs after submit in patron search (AngularJS)

[Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / 0900.schema.no-null-record_attrs.sql

BEGIN;

SELECT evergreen.upgrade_deps_block_check('0900', :eg_version);

CREATE OR REPLACE VIEW metabib.record_attr AS
    SELECT  id, HSTORE( ARRAY_AGG( attr ), ARRAY_AGG( value ) ) AS attrs
      FROM  metabib.record_attr_flat
      WHERE attr IS NOT NULL
      GROUP BY 1;

COMMIT;