LP#1400376: Don't allow NULL attrs to polute an HSTORE as a key

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

BEGIN;

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;