Schema evergreen
HomePrev Chapter 1. Database Schema Next

Schema evergreen

array_accum(anyelement)

Function Properties
Language: INTERNAL
Return Type: anyarray

array_overlap_check()

Function Properties
Language: PLPGSQL
Return Type: trigger

array_remove_item_by_value(el anyarray, inp anyelement)

Function Properties
Language: SQL
Return Type: anyarray

change_db_setting(settings text, setting_name text[])

Function Properties
Language: PLPGSQL
Return Type: void

coded_value_map_normalizer(ctype text, input text)

Function Properties
Language: SQL
Return Type: text

extract_marc_field(text, bigint, text)

Function Properties
Language: SQL
Return Type: text

extract_marc_field(text, bigint, text, text)

Function Properties
Language: PLPGSQL
Return Type: text

facet_force_nfc()

Function Properties
Language: PLPGSQL
Return Type: trigger

fake_fkey_tgr()

Function Properties
Language: PLPGSQL
Return Type: trigger

force_unicode_normal_form(form text, string text)

Function Properties
Language: PLPERLU
Return Type: text

generic_map_normalizer(text, text)

Function Properties
Language: PLPERLU
Return Type: text

get_barcodes(in_barcode integer, type text, select_ou text)

Given user input, find an appropriate barcode in the proper class. Will add prefix/suffix information to do so, and return all results.

Function Properties
Language: PLPGSQL
Return Type: SET OF barcode_set

is_json(text)

Function Properties
Language: PLPERLU
Return Type: boolean

limit_oustl()

Function Properties
Language: PLPGSQL
Return Type: trigger

lowercase(text)

Function Properties
Language: PLPERLU
Return Type: text

lpad_number_substrings(text, text, integer)

Function Properties
Language: PLPERLU
Return Type: text

maintain_901()

Function Properties
Language: PLPGSQL
Return Type: trigger

maintain_control_numbers()

Function Properties
Language: PLPERLU
Return Type: trigger

oils_i18n_code_tracking()

Function Properties
Language: PLPGSQL
Return Type: trigger

oils_i18n_gettext(integer, text, text, text)

Function Properties
Language: SQL
Return Type: text

oils_i18n_gettext(text, text, text, text)

Function Properties
Language: SQL
Return Type: text

oils_i18n_id_tracking()

Function Properties
Language: PLPGSQL
Return Type: trigger

oils_i18n_update_apply(hint text, new_ident text, old_ident text)

Function Properties
Language: PLPGSQL
Return Type: void

oils_i18n_xlate(raw_locale text, keyvalue text, identcol text, keycol text, keyclass text, keytable text)

Function Properties
Language: PLPGSQL
Return Type: text

oils_json_to_text(text)

Function Properties
Language: PLPERLU
Return Type: text

oils_text_as_bytea(text)

Function Properties
Language: SQL
Return Type: bytea

oils_tsearch2()

Function Properties
Language: PLPGSQL
Return Type: trigger

oils_xpath(text, text)

Function Properties
Language: SQL
Return Type: text[]

oils_xpath(text, text, anyarray)

Function Properties
Language: SQL
Return Type: text[]

oils_xpath_string(text, text)

Function Properties
Language: SQL
Return Type: text

oils_xpath_string(text, text, anyarray)

Function Properties
Language: SQL
Return Type: text

oils_xpath_string(text, text, text)

Function Properties
Language: SQL
Return Type: text

oils_xpath_string(text, text, text, anyarray)

Function Properties
Language: SQL
Return Type: text

oils_xpath_table(criteria text, xpaths text, relation_name text, document_field text, key text)

Function Properties
Language: PLPGSQL
Return Type: SET OF record

oils_xslt_process(text, text)

Function Properties
Language: PLPERLU
Return Type: text

org_top()

Function Properties
Language: SQL
Return Type: SET OF org_unit

ous_change_log()

Function Properties
Language: PLPGSQL
Return Type: trigger

ous_delete_log()

Function Properties
Language: PLPGSQL
Return Type: trigger

tableoid2name(oid)

Function Properties
Language: PLPGSQL
Return Type: text

upgrade_deps_block_check(my_applied_to text, my_db_patch text)

Function Properties
Language: PLPGSQL
Return Type: boolean

upgrade_list_applied_deprecated(my_db_patch text)

Function Properties
Language: SQL
Return Type: SET OF text

upgrade_list_applied_deprecates(my_db_patch text)

Function Properties
Language: SQL
Return Type: SET OF patch

upgrade_list_applied_superseded(my_db_patch text)

Function Properties
Language: SQL
Return Type: SET OF text

upgrade_list_applied_supersedes(my_db_patch text)

Function Properties
Language: SQL
Return Type: SET OF patch

upgrade_verify_no_dep_conflicts(my_db_patch text)

Function Properties
Language: SQL
Return Type: boolean

xml_escape(str text)

Function Properties
Language: SQL
Return Type: text

Prev Up Next
Schema container Home Schema extend_reporter

Report any errors in this documentation using Launchpad.
Documentation for Evergreen version 2.2
Copyright © 2007-2012, Memebers of the Evergreen Project