Evergreen
HomePrev   Next

Chapter 18. Schema public

Table of Contents

Functions in public

Below are the tables, views and functions for public

Functions in public

_get_parser_from_curcfg()

  • Language: SQL
  • Return Type: text

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

concat(tsvector, tsvector)

  • Language: INTERNAL
  • Return Type: tsvector

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

dex_init(internal)

  • Language: C
  • Return Type: internal

dex_lexize(internal, internal, integer)

  • Language: C
  • Return Type: internal

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

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

get_covers(tsvector, tsquery)

  • Language: C
  • 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

headline(oid, text, tsquery)

  • Language: INTERNAL
  • Return Type: text

headline(oid, text, tsquery, text)

  • Language: INTERNAL
  • Return Type: text

headline(text, text, tsquery)

  • Language: C
  • Return Type: text

headline(text, text, tsquery, text)

  • Language: C
  • Return Type: text

headline(text, tsquery)

  • Language: INTERNAL
  • Return Type: text

headline(text, tsquery, text)

  • Language: INTERNAL
  • Return Type: text

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

length(tsvector)

  • Language: INTERNAL
  • Return Type: integer

lexize(oid, text)

  • Language: INTERNAL
  • Return Type: text[]

lexize(text)

  • Language: C
  • Return Type: text[]

lexize(text, text)

  • Language: C
  • 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

numnode(tsquery)

  • Language: INTERNAL
  • Return Type: integer

oils_tsearch2()

  • Language: PLPGSQL
  • Return Type: trigger

parse(oid, text)

  • Language: INTERNAL
  • Return Type: SET OF tokenout

parse(text)

  • Language: C
  • Return Type: SET OF tokenout

parse(text, text)

  • Language: INTERNAL
  • Return Type: SET OF tokenout

plainto_tsquery(oid, text)

  • Language: INTERNAL
  • Return Type: tsquery

plainto_tsquery(text)

  • Language: INTERNAL
  • Return Type: tsquery

plainto_tsquery(text, text)

  • Language: C
  • Return Type: tsquery

populate_record(anyelement, public.hstore)

  • Language: C
  • Return Type: anyelement

prsd_end(internal)

  • Language: C
  • Return Type: void

prsd_getlexeme(internal, internal, internal)

  • Language: C
  • Return Type: integer

prsd_headline(internal, internal, internal)

  • Language: C
  • Return Type: internal

prsd_lextype(internal)

  • Language: C
  • Return Type: internal

prsd_start(internal, integer)

  • Language: C
  • Return Type: internal

querytree(tsquery)

  • Language: INTERNAL
  • Return Type: text

rank(real[], tsvector, tsquery)

  • Language: INTERNAL
  • Return Type: real

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

  • Language: INTERNAL
  • Return Type: real

rank(tsvector, tsquery)

  • Language: INTERNAL
  • Return Type: real

rank(tsvector, tsquery, integer)

  • Language: INTERNAL
  • Return Type: real

rank_cd(real[], tsvector, tsquery)

  • Language: INTERNAL
  • Return Type: real

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

  • Language: INTERNAL
  • Return Type: real

rank_cd(tsvector, tsquery)

  • Language: INTERNAL
  • Return Type: real

rank_cd(tsvector, tsquery, integer)

  • Language: INTERNAL
  • Return Type: real

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

reset_tsearch()

  • Language: C
  • Return Type: void

rewrite(tsquery, text)

  • Language: INTERNAL
  • Return Type: tsquery

rewrite(tsquery, tsquery, tsquery)

  • Language: INTERNAL
  • Return Type: tsquery

rewrite(tsquery[])

  • Language: INTERNAL
  • Return Type: tsquery

rewrite_accum(tsquery, tsquery[])

  • Language: C
  • Return Type: tsquery

rewrite_finish(tsquery)

  • Language: C
  • Return Type: tsquery

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

set_curcfg(integer)

  • Language: C
  • Return Type: void

set_curcfg(text)

  • Language: C
  • Return Type: void

set_curdict(integer)

  • Language: C
  • Return Type: void

set_curdict(text)

  • Language: C
  • Return Type: void

set_curprs(integer)

  • Language: C
  • Return Type: void

set_curprs(text)

  • Language: C
  • Return Type: void

setweight(tsvector, "char")

  • Language: INTERNAL
  • Return Type: tsvector

show_curcfg()

  • Language: INTERNAL
  • Return Type: oid

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[]

snb_en_init(internal)

  • Language: C
  • Return Type: internal

snb_lexize(internal, internal, integer)

  • Language: C
  • Return Type: internal

snb_ru_init(internal)

  • Language: C
  • Return Type: internal

snb_ru_init_koi8(internal)

  • Language: C
  • Return Type: internal

snb_ru_init_utf8(internal)

  • Language: C
  • Return Type: internal

spell_init(internal)

  • Language: C
  • Return Type: internal

spell_lexize(internal, internal, integer)

  • Language: C
  • Return Type: internal

split_date_range(text)

  • Language: SQL
  • Return Type: text

stat(text)

  • Language: INTERNAL
  • Return Type: SET OF statinfo

stat(text, text)

  • Language: INTERNAL
  • Return Type: SET OF statinfo

strip(tsvector)

  • Language: INTERNAL
  • Return Type: tsvector

svals(public.hstore)

  • Language: C
  • Return Type: SET OF text

syn_init(internal)

  • Language: C
  • Return Type: internal

syn_lexize(internal, internal, integer)

  • Language: C
  • Return Type: internal

tconvert(text, text)

  • Language: C
  • Return Type: hstore

text_concat(text, text)

  • Language: SQL
  • Return Type: text

thesaurus_init(internal)

  • Language: C
  • Return Type: internal

thesaurus_lexize(internal, internal, integer, internal)

  • Language: C
  • Return Type: internal

to_tsquery(oid, text)

  • Language: INTERNAL
  • Return Type: tsquery

to_tsquery(text)

  • Language: INTERNAL
  • Return Type: tsquery

to_tsquery(text, text)

  • Language: C
  • Return Type: tsquery

to_tsvector(oid, text)

  • Language: INTERNAL
  • Return Type: tsvector

to_tsvector(text)

  • Language: INTERNAL
  • Return Type: tsvector

to_tsvector(text, text)

  • Language: C
  • Return Type: tsvector

token_type()

  • Language: C
  • Return Type: SET OF tokentype

token_type(integer)

  • Language: INTERNAL
  • Return Type: SET OF tokentype

token_type(text)

  • Language: INTERNAL
  • Return Type: SET OF tokentype

translate_isbn1013(text)

  • Language: PLPERLU
  • Return Type: text

ts_debug(text)

  • Language: SQL
  • Return Type: SET OF tsdebug

tsearch2()

  • Language: C
  • Return Type: trigger

tsq_mcontained(tsquery, tsquery)

  • Language: INTERNAL
  • Return Type: boolean

tsq_mcontains(tsquery, tsquery)

  • Language: INTERNAL
  • Return Type: boolean

tsquery_and(tsquery, tsquery)

  • Language: INTERNAL
  • Return Type: tsquery

tsquery_not(tsquery)

  • Language: INTERNAL
  • Return Type: tsquery

tsquery_or(tsquery, tsquery)

  • Language: INTERNAL
  • Return Type: tsquery

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
Prev   Next
Functions in permission Home Chapter 19. Schema query