Open-ILS/src/sql/Pg/upgrade/0438.schema.bytea-index-label.sql

   1
   2 BEGIN;
   3
   4 INSERT INTO config.upgrade_log (version) VALUES ('0438'); -- miker
   5
   6 DROP INDEX asset.asset_call_number_upper_label_id_owning_lib_idx;
   7 CREATE INDEX asset_call_number_upper_label_id_owning_lib_idx ON asset.call_number (cast(upper(label) as bytea),id,owning_lib);
   8
   9 COMMIT;