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

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

extract_marc_field(text, bigint, text)

  • Language: SQL
  • Return Type: text

extract_marc_field(text, bigint, text, text)

  • Language: PLPGSQL
  • Return Type: text

facet_force_nfc()

  • Language: PLPGSQL
  • Return Type: trigger

fake_fkey_tgr()

  • Language: PLPGSQL
  • Return Type: trigger

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

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

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_tsearch2()

  • Language: PLPGSQL
  • Return Type: trigger

oils_xpath(text, text)

  • Language: SQL
  • Return Type: text[]

oils_xpath(text, text, anyarray)

  • 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_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

rank_cp_status(status integer)

  • Language: SQL
  • 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, pref_lib public.hstore, soffset integer)

  • Language: SQL
  • Return Type: SET OF record

regexp_split_to_array(text, text)

  • Language: PLPERLU
  • Return Type: text[]

tableoid2name(oid)

  • 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

xml_escape(str text)

  • Language: SQL
  • Return Type: text

xml_pretty_print(input xml)

  • Language: SQL
  • Return Type: xml