Chapter 18. Schema public

Table of Contents

Functions in public

Below are the tables, views and functions for public

Functions in public

agg_text(text). Language: INTERNAL Return Type: text

akeys(public.hstore). Language: C Return Type: text[]

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

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

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

avals(public.hstore). Language: C Return Type: text[]

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

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

cleanup_acq_marc(). Language: PLPGSQL Return Type: trigger

connectby(text, text, text, text, integer). Language: C Return Type: SET OF record

connectby(text, text, text, text, integer, text). Language: C Return Type: SET OF record

connectby(text, text, text, text, text, integer). Language: C Return Type: SET OF record

connectby(text, text, text, text, text, integer, text). Language: C Return Type: SET OF record

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

crosstab(text). Language: C Return Type: SET OF record

crosstab(text, integer). Language: C Return Type: SET OF record

crosstab(text, text). Language: C Return Type: SET OF record

crosstab2(text). Language: C Return Type: SET OF tablefunc_crosstab_2

crosstab3(text). Language: C Return Type: SET OF tablefunc_crosstab_3

crosstab4(text). Language: C Return Type: SET OF tablefunc_crosstab_4

defined(public.hstore, text). Language: C Return Type: boolean

delete(public.hstore, public.hstore). Language: C Return Type: hstore

delete(public.hstore, text). Language: C Return Type: hstore

delete(public.hstore, text[]). Language: C Return Type: hstore

each(value public.hstore). Language: C Return Type: SET OF record

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

exist(public.hstore, text). Language: C Return Type: boolean

exists_all(public.hstore, text[]). Language: C Return Type: boolean

exists_any(public.hstore, text[]). Language: C Return Type: boolean

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

extract_acq_marc_field_set(bigint, text, text). Language: SQL Return Type: SET OF text

fetchval(public.hstore, text). Language: C Return Type: text

first(anyelement). Language: INTERNAL Return Type: anyelement

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

first_agg(anyelement, anyelement). Language: SQL Return Type: anyelement

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

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

ghstore_compress(internal). Language: C Return Type: internal

ghstore_consistent(internal, internal, integer, oid, internal). Language: C Return Type: boolean

ghstore_decompress(internal). Language: C Return Type: internal

ghstore_in(cstring). Language: C Return Type: ghstore

ghstore_out(public.ghstore). Language: C Return Type: cstring

ghstore_penalty(internal, internal, internal). Language: C Return Type: internal

ghstore_picksplit(internal, internal). Language: C Return Type: internal

ghstore_same(internal, internal, internal). Language: C Return Type: internal

ghstore_union(internal, internal). Language: C Return Type: internal

gin_consistent_hstore(internal, smallint, internal, integer, internal, internal). Language: C Return Type: boolean

gin_extract_hstore(internal, internal). Language: C Return Type: internal

gin_extract_hstore_query(internal, internal, smallint, internal, internal). Language: C Return Type: internal

hs_concat(public.hstore, public.hstore). Language: C Return Type: hstore

hs_contained(public.hstore, public.hstore). Language: C Return Type: boolean

hs_contains(public.hstore, public.hstore). Language: C Return Type: boolean

hstore(record). Language: C Return Type: hstore

hstore(text, text). Language: C Return Type: hstore

hstore(text[]). Language: C Return Type: hstore

hstore(text[], text[]). Language: C Return Type: hstore

hstore_cmp(public.hstore, public.hstore). Language: C Return Type: integer

hstore_eq(public.hstore, public.hstore). Language: C Return Type: boolean

hstore_ge(public.hstore, public.hstore). Language: C Return Type: boolean

hstore_gt(public.hstore, public.hstore). Language: C Return Type: boolean

hstore_hash(public.hstore). Language: C Return Type: integer

hstore_in(cstring). Language: C Return Type: hstore

hstore_le(public.hstore, public.hstore). Language: C Return Type: boolean

hstore_lt(public.hstore, public.hstore). Language: C Return Type: boolean

hstore_ne(public.hstore, public.hstore). Language: C Return Type: boolean

hstore_out(public.hstore). Language: C Return Type: cstring

hstore_recv(internal). Language: C Return Type: hstore

hstore_send(public.hstore). Language: C Return Type: bytea

hstore_to_array(public.hstore). Language: C Return Type: text[]

hstore_to_matrix(public.hstore). Language: C Return Type: text[]

hstore_version_diag(public.hstore). Language: C Return Type: integer

ingest_acq_marc(). Language: PLPGSQL Return Type: trigger

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

isdefined(public.hstore, text). Language: C Return Type: boolean

isexists(public.hstore, text). Language: C Return Type: boolean

last(anyelement). Language: INTERNAL Return Type: anyelement

last_agg(anyelement, anyelement). Language: SQL Return Type: anyelement

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

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

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

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

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

non_filing_normalize(text, "char"). Language: SQL Return Type: text

normal_rand(integer, double precision, double precision). Language: C Return Type: SET OF double precision

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

oils_tsearch2(). Language: PLPGSQL Return Type: trigger

populate_record(anyelement, public.hstore). Language: C Return Type: anyelement

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

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

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

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

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

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

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

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

skeys(public.hstore). Language: C Return Type: SET OF text

slice(public.hstore, text[]). Language: C Return Type: hstore

slice_array(public.hstore, text[]). Language: C Return Type: text[]

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

svals(public.hstore). Language: C Return Type: SET OF text

tconvert(text, text). Language: C Return Type: hstore

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

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

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

xml_encode_special_chars(text). Language: C Return Type: text

xml_valid(text). Language: INTERNAL Return Type: boolean

xpath_bool(text, text). Language: C Return Type: boolean

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

xpath_list(text, text, text). Language: C Return Type: text

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

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

xpath_nodeset(text, text, text, text). Language: C Return Type: text

xpath_number(text, text). Language: C Return Type: real

xpath_string(text, text). Language: C Return Type: text

xpath_table(text, text, text, text, text). Language: C Return Type: SET OF record

xslt_process(text, text). Language: C Return Type: text

xslt_process(text, text, text). Language: C Return Type: text