Schema public
HomePrev Chapter 1. Database Schema Next

Schema public

standard public schema

_get_parser_from_curcfg()

Function Properties
Language: SQL
Return Type: text

agg_text(text)

Function Properties
Language: INTERNAL
Return Type: text

akeys(public.hstore)

Function Properties
Language: C
Return Type: text[]

approximate_date(text, text)

Function Properties
Language: SQL
Return Type: text

approximate_high_date(text)

Function Properties
Language: SQL
Return Type: text

approximate_low_date(text)

Function Properties
Language: SQL
Return Type: text

avals(public.hstore)

Function Properties
Language: C
Return Type: text[]

call_number_dewey(text)

Function Properties
Language: PLPERLU
Return Type: text

call_number_dewey(text, integer)

Function Properties
Language: SQL
Return Type: text

cleanup_acq_marc()

Function Properties
Language: PLPGSQL
Return Type: trigger

concat(tsvector, tsvector)

Function Properties
Language: INTERNAL
Return Type: tsvector

connectby(text, text, text, text, integer)

Function Properties
Language: C
Return Type: SET OF record

connectby(text, text, text, text, integer, text)

Function Properties
Language: C
Return Type: SET OF record

connectby(text, text, text, text, text, integer)

Function Properties
Language: C
Return Type: SET OF record

connectby(text, text, text, text, text, integer, text)

Function Properties
Language: C
Return Type: SET OF record

content_or_null(text)

Function Properties
Language: SQL
Return Type: text

crosstab(text)

Function Properties
Language: C
Return Type: SET OF record

crosstab(text, integer)

Function Properties
Language: C
Return Type: SET OF record

crosstab(text, text)

Function Properties
Language: C
Return Type: SET OF record

crosstab2(text)

Function Properties
Language: C
Return Type: SET OF tablefunc_crosstab_2

crosstab3(text)

Function Properties
Language: C
Return Type: SET OF tablefunc_crosstab_3

crosstab4(text)

Function Properties
Language: C
Return Type: SET OF tablefunc_crosstab_4

defined(public.hstore, text)

Function Properties
Language: C
Return Type: boolean

delete(public.hstore, public.hstore)

Function Properties
Language: C
Return Type: hstore

delete(public.hstore, text)

Function Properties
Language: C
Return Type: hstore

delete(public.hstore, text[])

Function Properties
Language: C
Return Type: hstore

dex_init(internal)

Function Properties
Language: C
Return Type: internal

dex_lexize(internal, internal, integer)

Function Properties
Language: C
Return Type: internal

each(value public.hstore)

Function Properties
Language: C
Return Type: SET OF record

entityize(text)

Function Properties
Language: PLPERLU
Return Type: text

exist(public.hstore, text)

Function Properties
Language: C
Return Type: boolean

exists_all(public.hstore, text[])

Function Properties
Language: C
Return Type: boolean

exists_any(public.hstore, text[])

Function Properties
Language: C
Return Type: boolean

extract_acq_marc_field(bigint, text, text)

Function Properties
Language: SQL
Return Type: text

fetchval(public.hstore, text)

Function Properties
Language: C
Return Type: text

first(anyelement)

Function Properties
Language: INTERNAL
Return Type: anyelement

first5(text)

Function Properties
Language: SQL
Return Type: text

first_agg(anyelement, anyelement)

Function Properties
Language: SQL
Return Type: anyelement

first_word(text)

Function Properties
Language: SQL
Return Type: text

force_to_isbn13(text)

Inspired by translate_isbn1013 The force_to_isbn13 function takes an input ISBN and returns the ISBN13 version without hypens and with a repaired checksum if the checksum was bad

Function Properties
Language: PLPERLU
Return Type: text

get_covers(tsvector, tsquery)

Function Properties
Language: C
Return Type: text

ghstore_compress(internal)

Function Properties
Language: C
Return Type: internal

ghstore_consistent(internal, internal, integer, oid, internal)

Function Properties
Language: C
Return Type: boolean

ghstore_decompress(internal)

Function Properties
Language: C
Return Type: internal

ghstore_in(cstring)

Function Properties
Language: C
Return Type: ghstore

ghstore_out(public.ghstore)

Function Properties
Language: C
Return Type: cstring

ghstore_penalty(internal, internal, internal)

Function Properties
Language: C
Return Type: internal

ghstore_picksplit(internal, internal)

Function Properties
Language: C
Return Type: internal

ghstore_same(internal, internal, internal)

Function Properties
Language: C
Return Type: internal

ghstore_union(internal, internal)

Function Properties
Language: C
Return Type: internal

gin_consistent_hstore(internal, smallint, internal, integer, internal, internal)

Function Properties
Language: C
Return Type: boolean

gin_extract_hstore(internal, internal)

Function Properties
Language: C
Return Type: internal

gin_extract_hstore_query(internal, internal, smallint, internal, internal)

Function Properties
Language: C
Return Type: internal

headline(oid, text, tsquery)

Function Properties
Language: INTERNAL
Return Type: text

headline(oid, text, tsquery, text)

Function Properties
Language: INTERNAL
Return Type: text

headline(text, text, tsquery)

Function Properties
Language: C
Return Type: text

headline(text, text, tsquery, text)

Function Properties
Language: C
Return Type: text

headline(text, tsquery)

Function Properties
Language: INTERNAL
Return Type: text

headline(text, tsquery, text)

Function Properties
Language: INTERNAL
Return Type: text

hs_concat(public.hstore, public.hstore)

Function Properties
Language: C
Return Type: hstore

hs_contained(public.hstore, public.hstore)

Function Properties
Language: C
Return Type: boolean

hs_contains(public.hstore, public.hstore)

Function Properties
Language: C
Return Type: boolean

hstore(record)

Function Properties
Language: C
Return Type: hstore

hstore(text, text)

Function Properties
Language: C
Return Type: hstore

hstore(text[])

Function Properties
Language: C
Return Type: hstore

hstore(text[], text[])

Function Properties
Language: C
Return Type: hstore

hstore_cmp(public.hstore, public.hstore)

Function Properties
Language: C
Return Type: integer

hstore_eq(public.hstore, public.hstore)

Function Properties
Language: C
Return Type: boolean

hstore_ge(public.hstore, public.hstore)

Function Properties
Language: C
Return Type: boolean

hstore_gt(public.hstore, public.hstore)

Function Properties
Language: C
Return Type: boolean

hstore_hash(public.hstore)

Function Properties
Language: C
Return Type: integer

hstore_in(cstring)

Function Properties
Language: C
Return Type: hstore

hstore_le(public.hstore, public.hstore)

Function Properties
Language: C
Return Type: boolean

hstore_lt(public.hstore, public.hstore)

Function Properties
Language: C
Return Type: boolean

hstore_ne(public.hstore, public.hstore)

Function Properties
Language: C
Return Type: boolean

hstore_out(public.hstore)

Function Properties
Language: C
Return Type: cstring

hstore_recv(internal)

Function Properties
Language: C
Return Type: hstore

hstore_send(public.hstore)

Function Properties
Language: C
Return Type: bytea

hstore_to_array(public.hstore)

Function Properties
Language: C
Return Type: text[]

hstore_to_matrix(public.hstore)

Function Properties
Language: C
Return Type: text[]

hstore_version_diag(public.hstore)

Function Properties
Language: C
Return Type: integer

ingest_acq_marc()

Function Properties
Language: PLPGSQL
Return Type: trigger

integer_or_null(text)

Function Properties
Language: SQL
Return Type: text

isdefined(public.hstore, text)

Function Properties
Language: C
Return Type: boolean

isexists(public.hstore, text)

Function Properties
Language: C
Return Type: boolean

last(anyelement)

Function Properties
Language: INTERNAL
Return Type: anyelement

last_agg(anyelement, anyelement)

Function Properties
Language: SQL
Return Type: anyelement

left_trunc(text, integer)

Function Properties
Language: SQL
Return Type: text

length(tsvector)

Function Properties
Language: INTERNAL
Return Type: integer

lexize(oid, text)

Function Properties
Language: INTERNAL
Return Type: text[]

lexize(text)

Function Properties
Language: C
Return Type: text[]

lexize(text, text)

Function Properties
Language: C
Return Type: text[]

lowercase(text)

Function Properties
Language: PLPERLU
Return Type: text

naco_normalize(text)

Function Properties
Language: SQL
Return Type: text

naco_normalize(text, text)

Function Properties
Language: PLPERLU
Return Type: text

naco_normalize_keep_comma(text)

Function Properties
Language: SQL
Return Type: text

non_filing_normalize(text, "char")

Function Properties
Language: SQL
Return Type: text

normal_rand(integer, double precision, double precision)

Function Properties
Language: C
Return Type: SET OF double precision

normalize_space(text)

Function Properties
Language: SQL
Return Type: text

numnode(tsquery)

Function Properties
Language: INTERNAL
Return Type: integer

oils_tsearch2()

Function Properties
Language: PLPGSQL
Return Type: trigger

parse(oid, text)

Function Properties
Language: INTERNAL
Return Type: SET OF tokenout

parse(text)

Function Properties
Language: C
Return Type: SET OF tokenout

parse(text, text)

Function Properties
Language: INTERNAL
Return Type: SET OF tokenout

plainto_tsquery(oid, text)

Function Properties
Language: INTERNAL
Return Type: tsquery

plainto_tsquery(text)

Function Properties
Language: INTERNAL
Return Type: tsquery

plainto_tsquery(text, text)

Function Properties
Language: C
Return Type: tsquery

populate_record(anyelement, public.hstore)

Function Properties
Language: C
Return Type: anyelement

prsd_end(internal)

Function Properties
Language: C
Return Type: void

prsd_getlexeme(internal, internal, internal)

Function Properties
Language: C
Return Type: integer

prsd_headline(internal, internal, internal)

Function Properties
Language: C
Return Type: internal

prsd_lextype(internal)

Function Properties
Language: C
Return Type: internal

prsd_start(internal, integer)

Function Properties
Language: C
Return Type: internal

querytree(tsquery)

Function Properties
Language: INTERNAL
Return Type: text

rank(real[], tsvector, tsquery)

Function Properties
Language: INTERNAL
Return Type: real

rank(real[], tsvector, tsquery, integer)

Function Properties
Language: INTERNAL
Return Type: real

rank(tsvector, tsquery)

Function Properties
Language: INTERNAL
Return Type: real

rank(tsvector, tsquery, integer)

Function Properties
Language: INTERNAL
Return Type: real

rank_cd(real[], tsvector, tsquery)

Function Properties
Language: INTERNAL
Return Type: real

rank_cd(real[], tsvector, tsquery, integer)

Function Properties
Language: INTERNAL
Return Type: real

rank_cd(tsvector, tsquery)

Function Properties
Language: INTERNAL
Return Type: real

rank_cd(tsvector, tsquery, integer)

Function Properties
Language: INTERNAL
Return Type: real

remove_commas(text)

Function Properties
Language: SQL
Return Type: text

remove_diacritics(text)

Function Properties
Language: PLPERLU
Return Type: text

remove_paren_substring(text)

Function Properties
Language: SQL
Return Type: text

remove_whitespace(text)

Function Properties
Language: SQL
Return Type: text

reset_tsearch()

Function Properties
Language: C
Return Type: void

rewrite(tsquery, text)

Function Properties
Language: INTERNAL
Return Type: tsquery

rewrite(tsquery, tsquery, tsquery)

Function Properties
Language: INTERNAL
Return Type: tsquery

rewrite(tsquery[])

Function Properties
Language: INTERNAL
Return Type: tsquery

rewrite_accum(tsquery, tsquery[])

Function Properties
Language: C
Return Type: tsquery

rewrite_finish(tsquery)

Function Properties
Language: C
Return Type: tsquery

right_trunc(text, integer)

Function Properties
Language: SQL
Return Type: text

search_normalize(text)

Function Properties
Language: SQL
Return Type: text

search_normalize(text, text)

Function Properties
Language: PLPERLU
Return Type: text

search_normalize_keep_comma(text)

Function Properties
Language: SQL
Return Type: text

set_curcfg(integer)

Function Properties
Language: C
Return Type: void

set_curcfg(text)

Function Properties
Language: C
Return Type: void

set_curdict(integer)

Function Properties
Language: C
Return Type: void

set_curdict(text)

Function Properties
Language: C
Return Type: void

set_curprs(integer)

Function Properties
Language: C
Return Type: void

set_curprs(text)

Function Properties
Language: C
Return Type: void

setweight(tsvector, "char")

Function Properties
Language: INTERNAL
Return Type: tsvector

show_curcfg()

Function Properties
Language: INTERNAL
Return Type: oid

skeys(public.hstore)

Function Properties
Language: C
Return Type: SET OF text

slice(public.hstore, text[])

Function Properties
Language: C
Return Type: hstore

slice_array(public.hstore, text[])

Function Properties
Language: C
Return Type: text[]

snb_en_init(internal)

Function Properties
Language: C
Return Type: internal

snb_lexize(internal, internal, integer)

Function Properties
Language: C
Return Type: internal

snb_ru_init(internal)

Function Properties
Language: C
Return Type: internal

snb_ru_init_koi8(internal)

Function Properties
Language: C
Return Type: internal

snb_ru_init_utf8(internal)

Function Properties
Language: C
Return Type: internal

spell_init(internal)

Function Properties
Language: C
Return Type: internal

spell_lexize(internal, internal, integer)

Function Properties
Language: C
Return Type: internal

split_date_range(text)

Function Properties
Language: SQL
Return Type: text

stat(text)

Function Properties
Language: INTERNAL
Return Type: SET OF statinfo

stat(text, text)

Function Properties
Language: INTERNAL
Return Type: SET OF statinfo

strip(tsvector)

Function Properties
Language: INTERNAL
Return Type: tsvector

svals(public.hstore)

Function Properties
Language: C
Return Type: SET OF text

syn_init(internal)

Function Properties
Language: C
Return Type: internal

syn_lexize(internal, internal, integer)

Function Properties
Language: C
Return Type: internal

tconvert(text, text)

Function Properties
Language: C
Return Type: hstore

text_concat(text, text)

Function Properties
Language: SQL
Return Type: text

thesaurus_init(internal)

Function Properties
Language: C
Return Type: internal

thesaurus_lexize(internal, internal, integer, internal)

Function Properties
Language: C
Return Type: internal

to_tsquery(oid, text)

Function Properties
Language: INTERNAL
Return Type: tsquery

to_tsquery(text)

Function Properties
Language: INTERNAL
Return Type: tsquery

to_tsquery(text, text)

Function Properties
Language: C
Return Type: tsquery

to_tsvector(oid, text)

Function Properties
Language: INTERNAL
Return Type: tsvector

to_tsvector(text)

Function Properties
Language: INTERNAL
Return Type: tsvector

to_tsvector(text, text)

Function Properties
Language: C
Return Type: tsvector

token_type()

Function Properties
Language: C
Return Type: SET OF tokentype

token_type(integer)

Function Properties
Language: INTERNAL
Return Type: SET OF tokentype

token_type(text)

Function Properties
Language: INTERNAL
Return Type: SET OF tokentype

translate_isbn1013(text)

The translate_isbn1013 function takes an input ISBN and returns the following in a single space-delimited string if the input ISBN is valid: - The normalized input ISBN (hyphens stripped) - The normalized input ISBN with a fixed checksum if the checksum was bad - The ISBN converted to its ISBN10 or ISBN13 counterpart, if possible

Function Properties
Language: PLPERLU
Return Type: text

ts_debug(text)

Function Properties
Language: SQL
Return Type: SET OF tsdebug

tsearch2()

Function Properties
Language: C
Return Type: trigger

tsq_mcontained(tsquery, tsquery)

Function Properties
Language: INTERNAL
Return Type: boolean

tsq_mcontains(tsquery, tsquery)

Function Properties
Language: INTERNAL
Return Type: boolean

tsquery_and(tsquery, tsquery)

Function Properties
Language: INTERNAL
Return Type: tsquery

tsquery_not(tsquery)

Function Properties
Language: INTERNAL
Return Type: tsquery

tsquery_or(tsquery, tsquery)

Function Properties
Language: INTERNAL
Return Type: tsquery

uppercase(text)

Function Properties
Language: PLPERLU
Return Type: text

xml_encode_special_chars(text)

Function Properties
Language: C
Return Type: text

xml_is_well_formed(text)

Function Properties
Language: C
Return Type: boolean

xml_valid(text)

Function Properties
Language: C
Return Type: boolean

xpath_bool(text, text)

Function Properties
Language: C
Return Type: boolean

xpath_list(text, text)

Function Properties
Language: SQL
Return Type: text

xpath_list(text, text, text)

Function Properties
Language: C
Return Type: text

xpath_nodeset(text, text)

Function Properties
Language: SQL
Return Type: text

xpath_nodeset(text, text, text)

Function Properties
Language: SQL
Return Type: text

xpath_nodeset(text, text, text, text)

Function Properties
Language: C
Return Type: text

xpath_number(text, text)

Function Properties
Language: C
Return Type: real

xpath_string(text, text)

Function Properties
Language: C
Return Type: text

xpath_table(text, text, text, text, text)

Function Properties
Language: C
Return Type: SET OF record

xslt_process(text, text)

Function Properties
Language: C
Return Type: text

xslt_process(text, text, text)

Function Properties
Language: C
Return Type: text

Prev Up Next
Schema permission Home Schema query

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