egdb3_12_9
.biblio
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
flatten_marc(rid bigint)
Parameters
Name
Type
Mode
rid
bigint
IN
Definition
DECLARE bib biblio.record_entry%ROWTYPE; output metabib.full_rec%ROWTYPE; field RECORD; BEGIN SELECT INTO bib * FROM biblio.record_entry WHERE id = rid; FOR field IN SELECT * FROM vandelay.flatten_marc( bib.marc ) LOOP output.record := rid; output.ind1 := field.ind1; output.ind2 := field.ind2; output.tag := field.tag; output.subfield := field.subfield; output.value := field.value; RETURN NEXT output; END LOOP; END;