adding function to public schema instead of non-existant (at this point in the instal...
[working/Evergreen.git] / Open-ILS / src / sql / Pg / 040.schema.asset.sql
index 84b4005..0a569f5 100644 (file)
@@ -121,6 +121,7 @@ CREATE TABLE asset.call_number (
 CREATE INDEX asset_call_number_record_idx ON asset.call_number (record);
 CREATE INDEX asset_call_number_creator_idx ON asset.call_number (creator);
 CREATE INDEX asset_call_number_editor_idx ON asset.call_number (editor);
+CREATE INDEX asset_call_number_dewey_idx ON asset.call_number (public.call_number_dewey(label));
 
 CREATE TABLE asset.call_number_note (
        id              BIGSERIAL                       PRIMARY KEY,