Routines

Routines

Name	Type	Language	Deterministic	Return Type	Security Restriction	Comments
update_combined_index_vectors(bib_id bigint)	FUNCTION	plpgsql	false	void	INVOKER
indexing_delete(bib biblio.record_entry, extra text DEFAULT NULL::text)	FUNCTION	plpgsql	false	boolean	INVOKER
browse_authority_pivot(integer[], text)	FUNCTION	sql	false	bigint	INVOKER
browse_authority_refs_pivot(integer[], text)	FUNCTION	sql	false	bigint	INVOKER
compile_composite_attr_cache_init()	FUNCTION	plperlu	false	boolean	INVOKER
reingest_metabib_field_entries(bib_id bigint, skip_facet boolean DEFAULT false, skip_display boolean DEFAULT false, skip_browse boolean DEFAULT false, skip_search boolean DEFAULT false, only_fields integer[] DEFAULT '{}'::integer[])	FUNCTION	plpgsql	false	void	INVOKER
compile_composite_attr(cattr_id integer)	FUNCTION	sql	true	query_int	INVOKER
facet_normalize_trigger()	FUNCTION	plpgsql	false	trigger	INVOKER
compile_composite_attr_cache_invalidate()	FUNCTION	sql	false	boolean	INVOKER
compile_composite_attr(cattr_def text)	FUNCTION	plperlu	true	query_int	INVOKER
suggest_browse_entries(raw_query_text text, search_class text, headline_opts text, visibility_org integer, query_limit integer, normalization integer)	FUNCTION	plpgsql	false	TABLE(value text, field integer, buoyant_and_class_match boolean, field_match boolean, field_weight integer, rank real, buoyant boolean, match text)	INVOKER
compile_composite_attr_cache_disable()	FUNCTION	plperlu	false	boolean	INVOKER
autosuggest_prepare_tsquery(orig text)	FUNCTION	plpgsql	false	text[]	INVOKER
browse(search_field integer[], browse_term text, context_org integer DEFAULT NULL::integer, context_loc_group integer DEFAULT NULL::integer, staff boolean DEFAULT false, pivot_id bigint DEFAULT NULL::bigint, result_limit integer DEFAULT 10)	FUNCTION	plpgsql	false	SETOF metabib.flat_browse_entry_appearance	INVOKER
browse_normalize(facet_text text, mapped_field integer)	FUNCTION	plpgsql	false	text	INVOKER
display_field_normalize_trigger()	FUNCTION	plpgsql	false	trigger	INVOKER
browse_pivot(integer[], text)	FUNCTION	sql	false	bigint	INVOKER
reingest_record_attributes(rid bigint, pattr_list text[] DEFAULT NULL::text[], prmarc text DEFAULT NULL::text, rdeleted boolean DEFAULT true)	FUNCTION	plpgsql	false	void	INVOKER
trim_trailing_punctuation(text)	FUNCTION	plpgsql	false	text	INVOKER
indexing_update(bib biblio.record_entry, insert_only boolean DEFAULT false, extra text DEFAULT NULL::text)	FUNCTION	plpgsql	false	boolean	INVOKER
browse_bib_pivot(integer[], text)	FUNCTION	sql	false	bigint	INVOKER
remap_metarecord_for_bib(bib_id bigint, fp text, bib_is_deleted boolean DEFAULT false, retain_deleted boolean DEFAULT false)	FUNCTION	plpgsql	false	bigint	INVOKER
browse(search_class text, browse_term text, context_org integer DEFAULT NULL::integer, context_loc_group integer DEFAULT NULL::integer, staff boolean DEFAULT false, pivot_id bigint DEFAULT NULL::bigint, result_limit integer DEFAULT 10)	FUNCTION	plpgsql	false	SETOF metabib.flat_browse_entry_appearance	INVOKER
composite_attr_def_cache_inval_tgr()	FUNCTION	plpgsql	false	trigger	INVOKER
reingest_metabib_full_rec(bib_id bigint)	FUNCTION	plpgsql	false	void	INVOKER
search_class_to_registered_components(search_class text)	FUNCTION	plpgsql	false	SETOF record	INVOKER
staged_browse(query text, fields integer[], context_org integer, context_locations integer[], staff boolean, browse_superpage_size integer, count_up_from_zero boolean, result_limit integer, next_pivot_pos integer)	FUNCTION	plpgsql	false	SETOF metabib.flat_browse_entry_appearance	INVOKER