Routines

Routines

Name Type Language Deterministic Return Type Security Restriction Comments
insertpalvelu(character varying, character varying) FUNCTION plpgsql false integer INVOKER
check_hetu(hetu text) FUNCTION plpgsql false boolean INVOKER
word_similarity_op(text, text) FUNCTION c false boolean INVOKER
word_similarity(text, text) FUNCTION c true real INVOKER
gin_trgm_consistent(internal, smallint, text, integer, internal, internal, internal, internal) FUNCTION c true boolean INVOKER
gtrgm_union(internal, internal) FUNCTION c true gtrgm INVOKER
unaccent(text) FUNCTION c false text INVOKER
insertkayttooikeus(character varying, character varying, character varying) FUNCTION plpgsql false integer INVOKER
random_hetu(orig_hetu text) FUNCTION plpgsql false text INVOKER
unaccent_init(internal) FUNCTION c false internal INVOKER
strict_word_similarity_commutator_op(text, text) FUNCTION c false boolean INVOKER
gtrgm_distance(internal, text, smallint, oid, internal) FUNCTION c true double precision INVOKER
gtrgm_in(cstring) FUNCTION c true gtrgm INVOKER
gtrgm_compress(internal) FUNCTION c true internal INVOKER
duplicate_search_fmt(text) FUNCTION sql true text INVOKER
gin_extract_query_trgm(text, internal, smallint, internal, internal, internal, internal) FUNCTION c true internal INVOKER
word_similarity_dist_op(text, text) FUNCTION c true real INVOKER
strict_word_similarity_op(text, text) FUNCTION c false boolean INVOKER
gtrgm_out(gtrgm) FUNCTION c true cstring INVOKER
gtrgm_penalty(internal, internal, internal) FUNCTION c true internal INVOKER
word_similarity_commutator_op(text, text) FUNCTION c false boolean INVOKER
random_hetu() FUNCTION plpgsql false text INVOKER
set_limit(real) FUNCTION c false real INVOKER
unaccent_lexize(internal, internal, internal, internal) FUNCTION c false internal INVOKER
strict_word_similarity_dist_op(text, text) FUNCTION c true real INVOKER
unaccent(regdictionary, text) FUNCTION c false text INVOKER
show_limit() FUNCTION c false real INVOKER
strict_word_similarity_dist_commutator_op(text, text) FUNCTION c true real INVOKER
gtrgm_consistent(internal, text, smallint, oid, internal) FUNCTION c true boolean INVOKER
gtrgm_decompress(internal) FUNCTION c true internal INVOKER
similarity_dist(text, text) FUNCTION c true real INVOKER
gtrgm_same(gtrgm, gtrgm, internal) FUNCTION c true internal INVOKER
similarity(text, text) FUNCTION c true real INVOKER
fix_vtj_update_by_linking_henkilos(original_oid text, duplicate_oid text) FUNCTION plpgsql false void INVOKER
show_trgm(text) FUNCTION c true text[] INVOKER
gin_trgm_triconsistent(internal, smallint, text, integer, internal, internal, internal) FUNCTION c true "char" INVOKER
hetu_run_anonymizer() FUNCTION plpgsql false integer INVOKER
strict_word_similarity(text, text) FUNCTION c true real INVOKER
similarity_op(text, text) FUNCTION c false boolean INVOKER
gin_extract_value_trgm(text, internal) FUNCTION c true internal INVOKER
gtrgm_picksplit(internal, internal) FUNCTION c true internal INVOKER
tarkistusmerkki(hetu text) FUNCTION plpgsql false character INVOKER
word_similarity_dist_commutator_op(text, text) FUNCTION c true real INVOKER
date_to_char(date) FUNCTION sql true text INVOKER