BEGIN
- EXECUTE ('TRUNCATE ' || c || ';');
+ EXECUTE ('DELETE FROM ' || c || ';');
EXECUTE ('INSERT INTO ' || c || ' (usr, barcode) SELECT id, usrname FROM ' || u || ';');
EXECUTE ('UPDATE ' || u || ' u SET card = c.id FROM ' || c || ' c WHERE c.usr = u.id;');
BEGIN
- TRUNCATE asset.opac_visible_copies;
+ DELETE FROM asset.opac_visible_copies;
INSERT INTO asset.opac_visible_copies (id, circ_lib, record)
- SELECT
+ SELECT DISTINCT
cp.id, cp.circ_lib, cn.record
FROM
asset.copy cp
cs.opac_visible AND
cl.opac_visible AND
cp.opac_visible AND
- a.opac_visible;
+ a.opac_visible AND
+ cp.id NOT IN (SELECT id FROM asset.opac_visible_copies);
END;