Routines

Routines

Name	Type	Language	Deterministic	Return Type	Security Restriction	Comments
hoksit_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
hmac(bytea, bytea, text)	FUNCTION	c	true	bytea	INVOKER
osaamisen_osoittamisen_osa_alue_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ahpto_arvioija_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
pgp_sym_decrypt_bytea(bytea, text, text)	FUNCTION	c	true	bytea	INVOKER
pgp_sym_encrypt(text, text)	FUNCTION	c	false	bytea	INVOKER
hyto_osa_alueen_osaamisen_hankkimistapa_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
pgp_pub_decrypt(bytea, bytea, text)	FUNCTION	c	true	text	INVOKER
dearmor(text)	FUNCTION	c	true	bytea	INVOKER
osaamisen_osoittamisen_arvioija_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
strict_word_similarity_dist_op(text, text)	FUNCTION	c	true	real	INVOKER
gtrgm_options(internal)	FUNCTION	c	true	void	INVOKER
show_limit()	FUNCTION	c	false	real	INVOKER
gtrgm_consistent(internal, text, smallint, oid, internal)	FUNCTION	c	true	boolean	INVOKER
similarity(text, text)	FUNCTION	c	true	real	INVOKER
gtrgm_same(gtrgm, gtrgm, internal)	FUNCTION	c	true	internal	INVOKER
show_trgm(text)	FUNCTION	c	true	text[]	INVOKER
ahyto_naytto_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
ahato_naytto_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
osaamisen_osoittamisen_koulutuksen_jarjestaja_arv_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
pgp_pub_encrypt_bytea(bytea, bytea)	FUNCTION	c	false	bytea	INVOKER
refresh_reporting(target_schema text)	FUNCTION	plpgsql	false	boolean	INVOKER
pgp_pub_decrypt_bytea(bytea, bytea)	FUNCTION	c	true	bytea	INVOKER
encrypt(bytea, bytea, text)	FUNCTION	c	true	bytea	INVOKER
gin_trgm_consistent(internal, smallint, text, integer, internal, internal, internal, internal)	FUNCTION	c	true	boolean	INVOKER
pgp_sym_decrypt_bytea(bytea, text)	FUNCTION	c	true	bytea	INVOKER
pgp_sym_encrypt_bytea(bytea, text, text)	FUNCTION	c	false	bytea	INVOKER
pgp_sym_decrypt(bytea, text)	FUNCTION	c	true	text	INVOKER
osaamisen_osoittaminen_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
gtrgm_in(cstring)	FUNCTION	c	true	gtrgm	INVOKER
gtrgm_compress(internal)	FUNCTION	c	true	internal	INVOKER
pgp_pub_encrypt(text, bytea)	FUNCTION	c	false	bytea	INVOKER
pgp_key_id(bytea)	FUNCTION	c	true	text	INVOKER
ahyto_osa_alueen_naytto_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
armor(bytea)	FUNCTION	c	true	text	INVOKER
gtrgm_out(gtrgm)	FUNCTION	c	true	cstring	INVOKER
ahpto_naytto_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
hato_osaamisen_hankkimistapa_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
strict_word_similarity_dist_commutator_op(text, text)	FUNCTION	c	true	real	INVOKER
pgp_pub_decrypt(bytea, bytea)	FUNCTION	c	true	text	INVOKER
todennettu_arviointi_lisatieto_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
pgp_armor_headers(text, OUT key text, OUT value text)	FUNCTION	c	true	SETOF record	INVOKER
tyopaikalla_jarj_koulutus_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
strict_word_similarity(text, text)	FUNCTION	c	true	real	INVOKER
gin_extract_value_trgm(text, internal)	FUNCTION	c	true	internal	INVOKER
word_similarity_dist_commutator_op(text, text)	FUNCTION	c	true	real	INVOKER
word_similarity_op(text, text)	FUNCTION	c	false	boolean	INVOKER
pgp_pub_decrypt_bytea(bytea, bytea, text)	FUNCTION	c	true	bytea	INVOKER
hato_naytto_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
hpto_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
hyto_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
gtrgm_union(internal, internal)	FUNCTION	c	true	gtrgm	INVOKER
osaamisen_hankkimistapa_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
armor(bytea, text[], text[])	FUNCTION	c	true	text	INVOKER
hpto_naytto_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
todennettu_arviointi_arvioija_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
pgp_sym_decrypt(bytea, text, text)	FUNCTION	c	true	text	INVOKER
ahyto_arvioija_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
gin_extract_query_trgm(text, internal, smallint, internal, internal, internal, internal)	FUNCTION	c	true	internal	INVOKER
decrypt(bytea, bytea, text)	FUNCTION	c	true	bytea	INVOKER
gtrgm_penalty(internal, internal, internal)	FUNCTION	c	true	internal	INVOKER
hato_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
pgp_pub_decrypt_bytea(bytea, bytea, text, text)	FUNCTION	c	true	bytea	INVOKER
digest(bytea, text)	FUNCTION	c	true	bytea	INVOKER
crypt(text, text)	FUNCTION	c	true	text	INVOKER
gin_trgm_triconsistent(internal, smallint, text, integer, internal, internal, internal)	FUNCTION	c	true	"char"	INVOKER
encrypt_iv(bytea, bytea, bytea, text)	FUNCTION	c	true	bytea	INVOKER
pgp_sym_encrypt(text, text, text)	FUNCTION	c	false	bytea	INVOKER
hyto_osa_alue_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
pgp_pub_encrypt_bytea(bytea, bytea, text)	FUNCTION	c	false	bytea	INVOKER
ahpto_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
word_similarity(text, text)	FUNCTION	c	true	real	INVOKER
add_reporting_constraints(target_schema text)	FUNCTION	plpgsql	false	boolean	INVOKER
ahyto_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
gen_salt(text)	FUNCTION	c	false	text	INVOKER
gen_random_uuid()	FUNCTION	c	false	uuid	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
pgp_pub_decrypt(bytea, bytea, text, text)	FUNCTION	c	true	text	INVOKER
pgp_pub_encrypt(text, bytea, text)	FUNCTION	c	false	bytea	INVOKER
word_similarity_dist_op(text, text)	FUNCTION	c	true	real	INVOKER
strict_word_similarity_op(text, text)	FUNCTION	c	false	boolean	INVOKER
word_similarity_commutator_op(text, text)	FUNCTION	c	false	boolean	INVOKER
ahato_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
gen_random_bytes(integer)	FUNCTION	c	false	bytea	INVOKER
set_limit(real)	FUNCTION	c	false	real	INVOKER
hmac(text, text, text)	FUNCTION	c	true	bytea	INVOKER
digest(text, text)	FUNCTION	c	true	bytea	INVOKER
similarity_dist(text, text)	FUNCTION	c	true	real	INVOKER
gtrgm_decompress(internal)	FUNCTION	c	true	internal	INVOKER
similarity_op(text, text)	FUNCTION	c	false	boolean	INVOKER
ahyto_osa_alue_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
gtrgm_picksplit(internal, internal)	FUNCTION	c	true	internal	INVOKER
decrypt_iv(bytea, bytea, bytea, text)	FUNCTION	c	true	bytea	INVOKER
pgp_sym_encrypt_bytea(bytea, text)	FUNCTION	c	false	bytea	INVOKER
hyto_osa_alueen_naytto_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
hpto_osaamisen_hankkimistapa_casc_delete()	FUNCTION	plpgsql	false	trigger	INVOKER
gen_salt(text, integer)	FUNCTION	c	false	text	INVOKER