3 INSERT INTO config.upgrade_log (version) VALUES ('0003');
5 CREATE OR REPLACE VIEW action.unfulfilled_hold_loops AS
9 FROM action.unfulfilled_hold_list u
10 JOIN asset.copy c ON (c.id = u.current_copy)
13 CREATE OR REPLACE VIEW action.unfulfilled_hold_min_loop AS
16 FROM action.unfulfilled_hold_loops
19 CREATE OR REPLACE VIEW action.unfulfilled_hold_innermost_loop AS
21 FROM action.unfulfilled_hold_loops l
22 JOIN action.unfulfilled_hold_min_loop m USING (hold)
23 WHERE l.count = m.min;