Routines

Routines

Name Type Language Deterministic Return Type Security Restriction Comments
atag_browse_top_refs(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 10, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
simple_heading_browse_center(atag_list integer[], q text, page integer DEFAULT 0, pagesize integer DEFAULT 9, thesauruses text DEFAULT ''::text) FUNCTION plpgsql false SETOF bigint INVOKER
flatten_marc(rid bigint) FUNCTION plpgsql false SETOF authority.full_rec INVOKER
btag_browse_center_refs(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 9, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
axis_authority_tags(a text) FUNCTION sql false integer[] INVOKER
indexing_delete(auth authority.record_entry, extra text DEFAULT NULL::text) FUNCTION plpgsql false boolean INVOKER
atag_authority_tags(atag text) FUNCTION sql false integer[] INVOKER
normalize_heading(marcxml text, no_thesaurus boolean) FUNCTION plpgsql false text INVOKER
simple_normalize_heading(marcxml text) FUNCTION sql false text INVOKER
axis_browse_top_refs(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 10, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
propagate_changes(aid bigint, bid bigint) FUNCTION plpgsql false bigint INVOKER
btag_search_heading(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 10, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
extract_headings(marc text, restrict integer[] DEFAULT NULL::integer[]) FUNCTION plpgsql false SETOF authority.heading INVOKER
axis_search_rank_refs(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 10, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
axis_search_heading_refs(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 10, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
atag_search_heading_refs(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 10, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
apply_propagate_changes(aid bigint, bid bigint) FUNCTION plpgsql false bigint INVOKER
reingest_authority_rec_descriptor(auth_id bigint) FUNCTION plpgsql false void INVOKER
atag_search_heading(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 10, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
generate_overlay_template(source_xml text) FUNCTION plpgsql false text INVOKER
atag_browse_top(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 10, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
atag_browse_center_refs(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 9, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
btag_browse_top(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 10, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
axis_search_rank(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 10, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
atag_search_rank_refs(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 10, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
btag_authority_tags(btag text) FUNCTION sql false integer[] INVOKER
simple_heading_browse_top(atag_list integer[], q text, page integer DEFAULT 0, pagesize integer DEFAULT 10, thesauruses text DEFAULT ''::text) FUNCTION plpgsql false SETOF bigint INVOKER
simple_heading_search_heading(atag_list integer[], q text, page integer DEFAULT 0, pagesize integer DEFAULT 10, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
normalize_heading_for_upsert() FUNCTION plpgsql false trigger INVOKER
atag_search_rank(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 10, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
calculate_authority_linking(rec_id bigint, rec_control_set integer, rec_marc_xml xml) FUNCTION plpgsql false SETOF authority.authority_linking INVOKER
generate_overlay_template(bigint) FUNCTION sql false text INVOKER
btag_search_rank_refs(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 10, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
simple_heading_set(marcxml text) FUNCTION plpgsql false SETOF authority.simple_heading INVOKER
merge_records(target_record bigint, source_record bigint) FUNCTION plpgsql false integer INVOKER
simple_heading_search_rank(atag_list integer[], q text, page integer DEFAULT 0, pagesize integer DEFAULT 10, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
btag_authority_tags_refs(btag text) FUNCTION sql false integer[] INVOKER
btag_search_heading_refs(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 10, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
normalize_heading(marcxml text) FUNCTION sql false text INVOKER

Extract the authority heading, thesaurus, and NACO-normalized values from an authority record. The primary purpose is to build a unique index to defend against duplicated authority records from the same thesaurus.
extract_thesaurus(marcxml text) FUNCTION plpgsql false text INVOKER
btag_browse_top_refs(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 10, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
simple_heading_find_pivot(a integer[], q text, thesauruses text DEFAULT ''::text) FUNCTION plpgsql false text INVOKER
atag_authority_tags_refs(atag text) FUNCTION sql false integer[] INVOKER
axis_browse_center_refs(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 9, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
axis_search_heading(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 10, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
atag_browse_center(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 9, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
axis_browse_center(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 9, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
axis_browse_top(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 10, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
btag_browse_center(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 9, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER
map_thesaurus_to_control_set() FUNCTION plpgsql false trigger INVOKER
axis_authority_tags_refs(a text) FUNCTION sql false integer[] INVOKER
extract_headings(rid bigint, restrict integer[] DEFAULT NULL::integer[]) FUNCTION plpgsql false SETOF authority.heading INVOKER
indexing_update(auth authority.record_entry, insert_only boolean DEFAULT false, old_heading text DEFAULT NULL::text) FUNCTION plpgsql false boolean INVOKER
propagate_changes(aid bigint) FUNCTION sql false SETOF bigint INVOKER
reingest_authority_full_rec(auth_id bigint) FUNCTION plpgsql false void INVOKER
btag_search_rank(a text, q text, page integer DEFAULT 0, pagesize integer DEFAULT 10, thesauruses text DEFAULT ''::text) FUNCTION sql false SETOF bigint INVOKER