Routines
| Name | Type | Language | Deterministic | Return Type | Security Restriction | Comments |
|---|---|---|---|---|---|---|
| abstract_tsvector() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| boxquery(integer, integer) | FUNCTION | sql | true | box | INVOKER | |
| boxrange(integer, integer) | FUNCTION | sql | true | box | INVOKER | |
| create_materialized_markerview(refresh boolean) | FUNCTION | plpgsql | false | boolean | INVOKER | |
| create_point(integer, integer) | FUNCTION | sql | false | point | INVOKER | |
| feature_disjoint_from(integer) | FUNCTION | sql | false | SETOF feature | INVOKER | |
| feature_overlaps(integer) | FUNCTION | sql | false | SETOF feature | INVOKER | |
| featureloc_slice(character varying, integer, integer) | FUNCTION | sql | false | SETOF featureloc | INVOKER | |
| featureloc_slice(integer, integer) | FUNCTION | sql | false | SETOF featureloc | INVOKER | |
| featureloc_slice(integer, integer, integer) | FUNCTION | sql | false | SETOF featureloc | INVOKER | |
| featureslice(integer, integer) | FUNCTION | sql | false | SETOF featureloc | INVOKER | |
| gffattstring(integer) | FUNCTION | plpgsql | false | character varying | INVOKER | |
| gfffeatureatts(integer) | FUNCTION | sql | false | SETOF gffatts | INVOKER | |
| gin_extract_query_trgm(text, internal, smallint, internal, internal, internal, internal) | FUNCTION | c | true | internal | INVOKER | |
| gin_extract_value_trgm(text, internal) | FUNCTION | c | true | internal | INVOKER | |
| gin_trgm_consistent(internal, smallint, text, integer, internal, internal, internal, internal) | FUNCTION | c | true | boolean | INVOKER | |
| gin_trgm_triconsistent(internal, smallint, text, integer, internal, internal, internal) | FUNCTION | c | true | "char" | INVOKER | |
| gtrgm_compress(internal) | FUNCTION | c | true | internal | INVOKER | |
| gtrgm_consistent(internal, text, smallint, oid, internal) | FUNCTION | c | true | boolean | INVOKER | |
| gtrgm_decompress(internal) | FUNCTION | c | true | internal | INVOKER | |
| gtrgm_distance(internal, text, smallint, oid, internal) | FUNCTION | c | true | double precision | INVOKER | |
| gtrgm_in(cstring) | FUNCTION | c | true | gtrgm | INVOKER | |
| gtrgm_out(gtrgm) | FUNCTION | c | true | cstring | INVOKER | |
| gtrgm_penalty(internal, internal, internal) | FUNCTION | c | true | internal | INVOKER | |
| gtrgm_picksplit(internal, internal) | FUNCTION | c | true | internal | INVOKER | |
| gtrgm_same(gtrgm, gtrgm, internal) | FUNCTION | c | true | internal | INVOKER | |
| gtrgm_union(internal, internal) | FUNCTION | c | true | gtrgm | INVOKER | |
| make_all_rows_visible_in_schema(scm character varying) | FUNCTION | plpgsql | false | boolean | INVOKER | |
| plpgsql_call_handler() | FUNCTION | c | false | language_handler | INVOKER | |
| plpgsql_validator(oid) | FUNCTION | c | false | void | INVOKER | |
| randstring(length integer) | FUNCTION | plpgsql | false | character varying | INVOKER | |
| refresh_materialized_phenotype_jsonb_table() | FUNCTION | sql | false | void | INVOKER | |
| refresh_materialized_phenotype_jsonb_table_concurrently() | FUNCTION | sql | false | void | INVOKER | |
| refresh_materialized_stockprop() | FUNCTION | sql | false | void | INVOKER | |
| refresh_materialized_stockprop_concurrently() | FUNCTION | sql | false | void | INVOKER | |
| set_limit(real) | FUNCTION | c | false | real | INVOKER | |
| show_limit() | FUNCTION | c | false | real | INVOKER | |
| show_trgm(text) | FUNCTION | c | true | text[] | INVOKER | |
| similarity(text, text) | FUNCTION | c | true | real | INVOKER | |
| similarity_dist(text, text) | FUNCTION | c | true | real | INVOKER | |
| similarity_op(text, text) | FUNCTION | c | false | boolean | INVOKER | |
| store_feature(character varying) | FUNCTION | plpgsql | false | integer | INVOKER | |
| store_feature(character varying, character varying, integer, integer, integer, text, integer, character, integer) | FUNCTION | plpgsql | false | integer | INVOKER | |
| store_feature_cvterm(integer, integer, integer) | FUNCTION | plpgsql | false | integer | INVOKER | |
| store_feature_dbxref(integer) | FUNCTION | plpgsql | false | integer | INVOKER | |
| store_feature_relationship(integer, integer, integer) | FUNCTION | plpgsql | false | integer | INVOKER | |
| store_featureprop(integer, integer, text, integer) | FUNCTION | plpgsql | false | integer | INVOKER | |
| store_featureprop_pub(integer, integer) | FUNCTION | plpgsql | false | integer | INVOKER | |
| store_gene(character varying) | FUNCTION | plpgsql | false | integer | INVOKER | |
| store_gene_feature(integer, integer) | FUNCTION | plpgsql | false | integer | INVOKER |
Processing...