Chapter 12. Schema evergreen

Table of Contents

Functions in evergreen

Below are the tables, views and functions for evergreen

Functions in evergreen

array_accum(anyelement). Language: INTERNAL Return Type: anyarray

array_overlap_check(). Language: PLPGSQL Return Type: trigger

array_remove_item_by_value(el anyarray, inp anyelement). Language: SQL Return Type: anyarray

asset_copy_alert_copy_inh_fkey(). Language: PLPGSQL Return Type: trigger

asset_copy_note_owning_copy_inh_fkey(). Language: PLPGSQL Return Type: trigger

asset_copy_tag_copy_map_copy_inh_fkey(). Language: PLPGSQL Return Type: trigger

asset_latest_inventory_copy_inh_fkey(). Language: PLPGSQL Return Type: trigger

can_float(to_ou integer, from_ou integer, copy_floating_group integer). Language: PLPGSQL Return Type: boolean

change_db_setting(settings text, setting_name text[]). Language: PLPGSQL Return Type: void

coded_value_map_normalizer(ctype text, input text). Language: SQL Return Type: text

container_copy_bucket_item_target_copy_inh_fkey(). Language: PLPGSQL Return Type: trigger

could_be_serial_holding_code(text). Language: PLPERLU Return Type: boolean

display_field_force_nfc(). Language: PLPGSQL Return Type: trigger

escape_for_html(text). Language: SQL Return Type: text

extract_marc_field(text, bigint, text). Language: SQL Return Type: text

extract_marc_field(text, bigint, text, text). Language: PLPGSQL Return Type: text

extract_marc_field_set(text, bigint, text, text). Language: PLPGSQL Return Type: SET OF text

facet_force_nfc(). Language: PLPGSQL Return Type: trigger

fake_fkey_tgr(). Language: PLPGSQL Return Type: trigger

find_next_open_time(dow_count integer, initial_time timestamp with time zone, hourly boolean, initial time without time zone, circ_lib integer). Language: PLPGSQL Return Type: timestamp with time zone

force_unicode_normal_form(form text, string text). Language: PLPERLU Return Type: text

generic_map_normalizer(text, text). Language: PLPERLU Return Type: text

get_barcodes(in_barcode integer, type text, select_ou text). Language: PLPGSQL Return Type: SET OF barcode_set

get_locale_name(description text). Language: PLPGSQL Return Type: record

is_json(text). Language: PLPERLU Return Type: boolean

limit_oustl(). Language: PLPGSQL Return Type: trigger

located_uris(rank bigint, label_sortkey integer, name integer). Language: SQL Return Type: SET OF record

located_uris(rank bigint[], label_sortkey integer, name integer). Language: SQL Return Type: SET OF record

lowercase(text). Language: PLPERLU Return Type: text

lpad_number_substrings(text, text, integer). Language: PLPERLU Return Type: text

maintain_901(). Language: PLPERLU Return Type: trigger

maintain_control_numbers(). Language: PLPERLU Return Type: trigger

marc_to(xfrm text, marc text). Language: SQL Return Type: text

oils_i18n_code_tracking(). Language: PLPGSQL Return Type: trigger

oils_i18n_gettext(integer, text, text, text). Language: SQL Return Type: text

oils_i18n_gettext(text, text, text, text). Language: SQL Return Type: text

oils_i18n_id_tracking(). Language: PLPGSQL Return Type: trigger

oils_i18n_update_apply(hint text, new_ident text, old_ident text). Language: PLPGSQL Return Type: void

oils_i18n_xlate(raw_locale text, keyvalue text, identcol text, keycol text, keyclass text, keytable text). Language: PLPGSQL Return Type: text

oils_json_to_text(text). Language: PLPERLU Return Type: text

oils_text_as_bytea(text). Language: SQL Return Type: bytea

oils_xpath(text, text). Language: SQL Return Type: text[]

oils_xpath(text, text, text[]). Language: SQL Return Type: text[]

oils_xpath_string(text, text). Language: SQL Return Type: text

oils_xpath_string(text, text, anyarray). Language: SQL Return Type: text

oils_xpath_string(text, text, text). Language: SQL Return Type: text

oils_xpath_string(text, text, text, anyarray). Language: SQL Return Type: text

oils_xpath_table(criteria text, xpaths text, relation_name text, document_field text, key text). Language: PLPGSQL Return Type: SET OF record

oils_xpath_tag_to_table(xpaths text, tag text, marc text[]). Language: PLPGSQL Return Type: SET OF record

oils_xslt_process(text, text). Language: PLPERLU Return Type: text

org_top(). Language: SQL Return Type: SET OF org_unit

ous_change_log(). Language: PLPGSQL Return Type: trigger

ous_delete_log(). Language: PLPGSQL Return Type: trigger

pg_statistics(frequency text, element text). Language: PLPGSQL Return Type: SET OF record

protect_reserved_rows_from_delete(). Language: PLPGSQL Return Type: trigger

query_int_wrapper(integer[], text). Language: PLPGSQL Return Type: boolean

rank_cp(copy asset.copy). Language: PLPGSQL Return Type: integer

rank_cp(copy_id bigint). Language: PLPGSQL Return Type: integer

rank_ou(pref_lib integer, search_lib integer, lib integer). Language: SQL Return Type: integer

ranked_volumes(rank bigint, label_sortkey integer, name integer, id public.hstore, includes public.hstore, pref_lib integer, soffset text[]). Language: SQL Return Type: SET OF record

ranked_volumes(rank bigint[], label_sortkey integer, name integer, id public.hstore, includes public.hstore, pref_lib integer, soffset text[]). Language: SQL Return Type: SET OF record

regexp_split_to_array(text, text). Language: PLPERLU Return Type: text[]

rel_bump(mults text[], bumps text, value text[], terms numeric[]). Language: PLPERLU Return Type: numeric

tableoid2name(oid). Language: PLPGSQL Return Type: text

unaccent_and_squash(arg text). Language: PLPGSQL Return Type: text

upgrade_deps_block_check(my_applied_to text, my_db_patch text). Language: PLPGSQL Return Type: boolean

upgrade_list_applied_deprecated(my_db_patch text). Language: SQL Return Type: SET OF text

upgrade_list_applied_deprecates(my_db_patch text). Language: SQL Return Type: SET OF patch

upgrade_list_applied_superseded(my_db_patch text). Language: SQL Return Type: SET OF text

upgrade_list_applied_supersedes(my_db_patch text). Language: SQL Return Type: SET OF patch

upgrade_verify_no_dep_conflicts(my_db_patch text). Language: SQL Return Type: boolean

vandelay_import_item_imported_as_inh_fkey(). Language: PLPGSQL Return Type: trigger

xml_escape(str text). Language: SQL Return Type: text

xml_famous5_to_text(text). Language: SQL Return Type: text

xml_pretty_print(input xml). Language: SQL Return Type: xml

z3950_attr_name_is_valid(). Language: PLPGSQL Return Type: trigger