Routines
| Name | Type | Language | Deterministic | Return Type | Security Restriction | Comments |
|---|---|---|---|---|---|---|
| _lt_q_regex(ltree[], lquery[]) | FUNCTION | c | true | boolean | INVOKER | |
| _lt_q_rregex(lquery[], ltree[]) | FUNCTION | c | true | boolean | INVOKER | |
| _ltq_extract_regex(ltree[], lquery) | FUNCTION | c | true | ltree | INVOKER | |
| _ltq_regex(ltree[], lquery) | FUNCTION | c | true | boolean | INVOKER | |
| _ltq_rregex(lquery, ltree[]) | FUNCTION | c | true | boolean | INVOKER | |
| _ltree_compress(internal) | FUNCTION | c | true | internal | INVOKER | |
| _ltree_consistent(internal, ltree[], smallint, oid, internal) | FUNCTION | c | true | boolean | INVOKER | |
| _ltree_extract_isparent(ltree[], ltree) | FUNCTION | c | true | ltree | INVOKER | |
| _ltree_extract_risparent(ltree[], ltree) | FUNCTION | c | true | ltree | INVOKER | |
| _ltree_gist_options(internal) | FUNCTION | c | true | void | INVOKER | |
| _ltree_isparent(ltree[], ltree) | FUNCTION | c | true | boolean | INVOKER | |
| _ltree_penalty(internal, internal, internal) | FUNCTION | c | true | internal | INVOKER | |
| _ltree_picksplit(internal, internal) | FUNCTION | c | true | internal | INVOKER | |
| _ltree_r_isparent(ltree, ltree[]) | FUNCTION | c | true | boolean | INVOKER | |
| _ltree_r_risparent(ltree, ltree[]) | FUNCTION | c | true | boolean | INVOKER | |
| _ltree_risparent(ltree[], ltree) | FUNCTION | c | true | boolean | INVOKER | |
| _ltree_same(ltree_gist, ltree_gist, internal) | FUNCTION | c | true | internal | INVOKER | |
| _ltree_union(internal, internal) | FUNCTION | c | true | ltree_gist | INVOKER | |
| _ltxtq_exec(ltree[], ltxtquery) | FUNCTION | c | true | boolean | INVOKER | |
| _ltxtq_extract_exec(ltree[], ltxtquery) | FUNCTION | c | true | ltree | INVOKER | |
| _ltxtq_rexec(ltxtquery, ltree[]) | FUNCTION | c | true | boolean | INVOKER | |
| armor(bytea) | FUNCTION | c | true | text | INVOKER | |
| armor(bytea, text[], text[]) | FUNCTION | c | true | text | INVOKER | |
| crypt(text, text) | FUNCTION | c | true | text | INVOKER | |
| dearmor(text) | FUNCTION | c | true | bytea | INVOKER | |
| decrypt(bytea, bytea, text) | FUNCTION | c | true | bytea | INVOKER | |
| decrypt_iv(bytea, bytea, bytea, text) | FUNCTION | c | true | bytea | INVOKER | |
| digest(bytea, text) | FUNCTION | c | true | bytea | INVOKER | |
| digest(text, text) | FUNCTION | c | true | bytea | INVOKER | |
| encrypt(bytea, bytea, text) | FUNCTION | c | true | bytea | INVOKER | |
| encrypt_iv(bytea, bytea, bytea, text) | FUNCTION | c | true | bytea | INVOKER | |
| gen_random_bytes(integer) | FUNCTION | c | false | bytea | INVOKER | |
| gen_random_uuid() | FUNCTION | c | false | uuid | INVOKER | |
| gen_salt(text) | FUNCTION | c | false | text | INVOKER | |
| gen_salt(text, integer) | FUNCTION | c | false | text | INVOKER | |
| hmac(bytea, bytea, text) | FUNCTION | c | true | bytea | INVOKER | |
| hmac(text, text, text) | FUNCTION | c | true | bytea | INVOKER | |
| index(ltree, ltree) | FUNCTION | c | true | integer | INVOKER | |
| index(ltree, ltree, integer) | FUNCTION | c | true | integer | INVOKER | |
| lca(ltree, ltree) | FUNCTION | c | true | ltree | INVOKER | |
| lca(ltree, ltree, ltree) | FUNCTION | c | true | ltree | INVOKER | |
| lca(ltree, ltree, ltree, ltree) | FUNCTION | c | true | ltree | INVOKER | |
| lca(ltree, ltree, ltree, ltree, ltree) | FUNCTION | c | true | ltree | INVOKER | |
| lca(ltree, ltree, ltree, ltree, ltree, ltree) | FUNCTION | c | true | ltree | INVOKER | |
| lca(ltree, ltree, ltree, ltree, ltree, ltree, ltree) | FUNCTION | c | true | ltree | INVOKER | |
| lca(ltree, ltree, ltree, ltree, ltree, ltree, ltree, ltree) | FUNCTION | c | true | ltree | INVOKER | |
| lca(ltree[]) | FUNCTION | c | true | ltree | INVOKER | |
| lquery_in(cstring) | FUNCTION | c | true | lquery | INVOKER | |
| lquery_out(lquery) | FUNCTION | c | true | cstring | INVOKER | |
| lquery_recv(internal) | FUNCTION | c | true | lquery | INVOKER | |
| lquery_send(lquery) | FUNCTION | c | true | bytea | INVOKER | |
| lt_q_regex(ltree, lquery[]) | FUNCTION | c | true | boolean | INVOKER | |
| lt_q_rregex(lquery[], ltree) | FUNCTION | c | true | boolean | INVOKER | |
| ltq_regex(ltree, lquery) | FUNCTION | c | true | boolean | INVOKER | |
| ltq_rregex(lquery, ltree) | FUNCTION | c | true | boolean | INVOKER | |
| ltree2text(ltree) | FUNCTION | c | true | text | INVOKER | |
| ltree_addltree(ltree, ltree) | FUNCTION | c | true | ltree | INVOKER | |
| ltree_addtext(ltree, text) | FUNCTION | c | true | ltree | INVOKER | |
| ltree_cmp(ltree, ltree) | FUNCTION | c | true | integer | INVOKER | |
| ltree_compress(internal) | FUNCTION | c | true | internal | INVOKER | |
| ltree_consistent(internal, ltree, smallint, oid, internal) | FUNCTION | c | true | boolean | INVOKER | |
| ltree_decompress(internal) | FUNCTION | c | true | internal | INVOKER | |
| ltree_eq(ltree, ltree) | FUNCTION | c | true | boolean | INVOKER | |
| ltree_ge(ltree, ltree) | FUNCTION | c | true | boolean | INVOKER | |
| ltree_gist_in(cstring) | FUNCTION | c | true | ltree_gist | INVOKER | |
| ltree_gist_options(internal) | FUNCTION | c | true | void | INVOKER | |
| ltree_gist_out(ltree_gist) | FUNCTION | c | true | cstring | INVOKER | |
| ltree_gt(ltree, ltree) | FUNCTION | c | true | boolean | INVOKER | |
| ltree_in(cstring) | FUNCTION | c | true | ltree | INVOKER | |
| ltree_isparent(ltree, ltree) | FUNCTION | c | true | boolean | INVOKER | |
| ltree_le(ltree, ltree) | FUNCTION | c | true | boolean | INVOKER | |
| ltree_lt(ltree, ltree) | FUNCTION | c | true | boolean | INVOKER | |
| ltree_ne(ltree, ltree) | FUNCTION | c | true | boolean | INVOKER | |
| ltree_out(ltree) | FUNCTION | c | true | cstring | INVOKER | |
| ltree_penalty(internal, internal, internal) | FUNCTION | c | true | internal | INVOKER | |
| ltree_picksplit(internal, internal) | FUNCTION | c | true | internal | INVOKER | |
| ltree_recv(internal) | FUNCTION | c | true | ltree | INVOKER | |
| ltree_risparent(ltree, ltree) | FUNCTION | c | true | boolean | INVOKER | |
| ltree_same(ltree_gist, ltree_gist, internal) | FUNCTION | c | true | internal | INVOKER | |
| ltree_send(ltree) | FUNCTION | c | true | bytea | INVOKER | |
| ltree_textadd(text, ltree) | FUNCTION | c | true | ltree | INVOKER | |
| ltree_union(internal, internal) | FUNCTION | c | true | ltree_gist | INVOKER | |
| ltreeparentsel(internal, oid, internal, integer) | FUNCTION | c | true | double precision | INVOKER | |
| ltxtq_exec(ltree, ltxtquery) | FUNCTION | c | true | boolean | INVOKER | |
| ltxtq_in(cstring) | FUNCTION | c | true | ltxtquery | INVOKER | |
| ltxtq_out(ltxtquery) | FUNCTION | c | true | cstring | INVOKER | |
| ltxtq_recv(internal) | FUNCTION | c | true | ltxtquery | INVOKER | |
| ltxtq_rexec(ltxtquery, ltree) | FUNCTION | c | true | boolean | INVOKER | |
| ltxtq_send(ltxtquery) | FUNCTION | c | true | bytea | INVOKER | |
| nlevel(ltree) | FUNCTION | c | true | integer | INVOKER | |
| pgp_armor_headers(text, OUT key text, OUT value text) | FUNCTION | c | true | SETOF record | INVOKER | |
| pgp_key_id(bytea) | FUNCTION | c | true | text | INVOKER | |
| pgp_pub_decrypt(bytea, bytea) | FUNCTION | c | true | text | INVOKER | |
| pgp_pub_decrypt(bytea, bytea, text) | FUNCTION | c | true | text | INVOKER | |
| pgp_pub_decrypt(bytea, bytea, text, text) | FUNCTION | c | true | text | INVOKER | |
| pgp_pub_decrypt_bytea(bytea, bytea) | FUNCTION | c | true | bytea | INVOKER | |
| pgp_pub_decrypt_bytea(bytea, bytea, text) | FUNCTION | c | true | bytea | INVOKER | |
| pgp_pub_decrypt_bytea(bytea, bytea, text, text) | FUNCTION | c | true | bytea | INVOKER | |
| pgp_pub_encrypt(text, bytea) | FUNCTION | c | false | bytea | INVOKER | |
| pgp_pub_encrypt(text, bytea, text) | FUNCTION | c | false | bytea | INVOKER | |
| pgp_pub_encrypt_bytea(bytea, bytea) | FUNCTION | c | false | bytea | INVOKER | |
| pgp_pub_encrypt_bytea(bytea, bytea, text) | FUNCTION | c | false | bytea | INVOKER | |
| pgp_sym_decrypt(bytea, text) | FUNCTION | c | true | text | INVOKER | |
| pgp_sym_decrypt(bytea, text, text) | FUNCTION | c | true | text | INVOKER | |
| pgp_sym_decrypt_bytea(bytea, text) | FUNCTION | c | true | bytea | INVOKER | |
| pgp_sym_decrypt_bytea(bytea, text, text) | FUNCTION | c | true | bytea | INVOKER | |
| pgp_sym_encrypt(text, text) | FUNCTION | c | false | bytea | INVOKER | |
| pgp_sym_encrypt(text, text, text) | FUNCTION | c | false | bytea | INVOKER | |
| pgp_sym_encrypt_bytea(bytea, text) | FUNCTION | c | false | bytea | INVOKER | |
| pgp_sym_encrypt_bytea(bytea, text, text) | FUNCTION | c | false | bytea | INVOKER | |
| subltree(ltree, integer, integer) | FUNCTION | c | true | ltree | INVOKER | |
| subpath(ltree, integer) | FUNCTION | c | true | ltree | INVOKER | |
| subpath(ltree, integer, integer) | FUNCTION | c | true | ltree | INVOKER | |
| text2ltree(text) | FUNCTION | c | true | ltree | INVOKER |
Processing...
Showing 1 to 114 of 114 entries