egdb3_14_1
.vandelay
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
auto_overlay_bib_queue_with_best(queue_id bigint, merge_profile_id integer, lwm_ratio_value numeric)
Parameters
Name
Type
Mode
queue_id
bigint
IN
merge_profile_id
integer
IN
lwm_ratio_value
numeric
IN
Definition
DECLARE queued_record vandelay.queued_bib_record%ROWTYPE; BEGIN FOR queued_record IN SELECT * FROM vandelay.queued_bib_record WHERE queue = queue_id AND import_time IS NULL LOOP IF vandelay.auto_overlay_bib_record_with_best( queued_record.id, merge_profile_id, lwm_ratio_value ) THEN RETURN NEXT queued_record.id; END IF; END LOOP; RETURN; END;