4 INSERT INTO config.upgrade_log (version) VALUES ('0139'); -- Dan Wells via miker
6 CREATE OR REPLACE FUNCTION vandelay.ingest_bib_items ( ) RETURNS TRIGGER AS $func$
9 item_data vandelay.import_item%ROWTYPE;
12 SELECT item_attr_def INTO attr_def FROM vandelay.bib_queue WHERE id = NEW.queue;
14 FOR item_data IN SELECT * FROM vandelay.ingest_items( NEW.id::BIGINT, attr_def ) LOOP
15 INSERT INTO vandelay.import_item (
42 item_data.call_number,
43 item_data.copy_number,
48 item_data.deposit_amount,
53 item_data.circ_modifier,
54 item_data.circ_as_type,
55 item_data.alert_message,
58 item_data.opac_visible
64 $func$ LANGUAGE PLPGSQL;