Routines
| Name | Type | Language | Deterministic | Return Type | Security Restriction | Comments |
|---|---|---|---|---|---|---|
| word_similarity_op(text, text) | FUNCTION | c | false | boolean | INVOKER | |
| versioning() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| setup_temporal_table(schema_name text, table_name text, auto_sync boolean DEFAULT false) | FUNCTION | plpgsql | false | void | INVOKER | Sets up temporal table tracking for a table. When auto_sync is true, synchronizes history table schema with source table. |
| word_similarity(text, text) | FUNCTION | c | true | real | INVOKER | |
| gtrgm_out(rst.gtrgm) | FUNCTION | c | true | cstring | INVOKER | |
| gtrgm_union(internal, internal) | FUNCTION | c | true | rst.gtrgm | INVOKER | |
| gin_trgm_consistent(internal, smallint, text, integer, internal, internal, internal, internal) | FUNCTION | c | true | boolean | INVOKER | |
| sync_temporal_table_schema(schema_name text, table_name text) | FUNCTION | plpgsql | false | jsonb | INVOKER | Synchronizes history table schema with source table by adding missing columns. Returns JSON with details of added columns. |
| 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 | rst.gtrgm | INVOKER | |
| update_if_changed() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| gtrgm_compress(internal) | FUNCTION | c | true | internal | 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 | |
| setup_temporal_table(schema_name text, table_name text) | FUNCTION | plpgsql | false | void | INVOKER | |
| sync_all_temporal_tables(schema_name text) | FUNCTION | plpgsql | false | jsonb | INVOKER | Synchronizes all temporal tables in a schema. Returns JSON with details of all changes made. |
| strict_word_similarity_op(text, text) | FUNCTION | c | false | boolean | INVOKER | |
| word_similarity_commutator_op(text, text) | FUNCTION | c | false | boolean | INVOKER | |
| gtrgm_penalty(internal, internal, internal) | FUNCTION | c | true | internal | INVOKER | |
| set_limit(real) | FUNCTION | c | false | real | INVOKER | |
| gtrgm_options(internal) | FUNCTION | c | true | void | INVOKER | |
| strict_word_similarity_dist_op(text, text) | FUNCTION | c | true | real | INVOKER | |
| gtrgm_same(rst.gtrgm, rst.gtrgm, internal) | FUNCTION | c | true | internal | 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 | |
| similarity_dist(text, text) | FUNCTION | c | true | real | INVOKER | |
| gtrgm_decompress(internal) | FUNCTION | c | true | internal | INVOKER | |
| similarity(text, text) | FUNCTION | c | true | real | INVOKER | |
| show_trgm(text) | FUNCTION | c | true | text[] | INVOKER | |
| gin_trgm_triconsistent(internal, smallint, text, integer, internal, internal, internal) | FUNCTION | c | true | "char" | INVOKER | |
| strict_word_similarity(text, text) | FUNCTION | c | true | real | INVOKER | |
| similarity_op(text, text) | FUNCTION | c | false | boolean | INVOKER | |
| upsert_timestamp_columns(schema_name text, table_name text, updated_at_only boolean DEFAULT false) | FUNCTION | plpgsql | false | void | INVOKER | |
| gin_extract_value_trgm(text, internal) | FUNCTION | c | true | internal | INVOKER | |
| gtrgm_picksplit(internal, internal) | FUNCTION | c | true | internal | INVOKER | |
| word_similarity_dist_commutator_op(text, text) | FUNCTION | c | true | real | INVOKER |