egdb3_13_6
.biblio
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
map_authority_linking(bibid bigint, marc text)
Parameters
Name
Type
Mode
bibid
bigint
IN
marc
text
IN
Definition
DELETE FROM authority.bib_linking WHERE bib = $1; INSERT INTO authority.bib_linking (bib, authority) SELECT y.bib, y.authority FROM ( SELECT DISTINCT $1 AS bib, BTRIM(remove_paren_substring(txt))::BIGINT AS authority FROM unnest(oils_xpath('//*[@code="0"]/text()',$2)) x(txt) WHERE BTRIM(remove_paren_substring(txt)) ~ $re$^\d+$$re$ ) y JOIN authority.record_entry r ON r.id = y.authority; SELECT $1;