egdb3_11_7
.vandelay
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
flatten_marc(marc text)
Parameters
Name
Type
Mode
marc
text
IN
Definition
DECLARE output vandelay.flat_marc%ROWTYPE; field RECORD; BEGIN FOR field IN SELECT * FROM vandelay.flay_marc( marc ) LOOP output.ind1 := field.ind1; output.ind2 := field.ind2; output.tag := field.tag; output.subfield := field.subfield; IF field.subfield IS NOT NULL AND field.tag NOT IN ('020','022','024') THEN -- exclude standard numbers and control fields output.value := naco_normalize(field.value, field.subfield); ELSE output.value := field.value; END IF; CONTINUE WHEN output.value IS NULL; RETURN NEXT output; END LOOP; END;