3 INSERT INTO config.upgrade_log (version) VALUES ('0194'); -- miker
5 CREATE OR REPLACE FUNCTION vandelay.auto_overlay_bib_record ( import_id BIGINT, merge_profile_id INT ) RETURNS BOOL AS $$
9 match_attr vandelay.bib_attr_definition%ROWTYPE;
11 SELECT COUNT(*) INTO match_count FROM vandelay.bib_match WHERE queued_record = import_id;
13 IF match_count <> 1 THEN
14 -- RAISE NOTICE 'not an exact match';
18 SELECT d.* INTO match_attr
19 FROM vandelay.bib_attr_definition d
20 JOIN vandelay.queued_bib_record_attr a ON (a.field = d.id)
21 JOIN vandelay.bib_match m ON (m.matched_attr = a.id)
22 WHERE m.queued_record = import_id;
24 IF NOT (match_attr.xpath ~ '@tag="901"' AND match_attr.xpath ~ '@code="c"') THEN
25 -- RAISE NOTICE 'not a 901c match';
29 SELECT m.eg_record INTO eg_id
30 FROM vandelay.bib_match m
31 WHERE m.queued_record = import_id
38 RETURN vandelay.overlay_bib_record( import_id, eg_id, merge_profile_id );