ash_postgres/lib/functions/trigram_similarity.ex
2022-08-24 12:07:38 -04:00

17 lines
573 B
Elixir

defmodule AshPostgres.Functions.TrigramSimilarity do
@moduledoc """
Maps to the builtin postgres trigram similarity function. Requires `pgtrgm` extension to be installed.
See the postgres docs on [trigram](https://www.postgresql.org/docs/9.6/pgtrgm.html]) for more information.
Requires the pg_trgm extension. Configure which extensions you have installed in your `AshPostgres.Repo`
# Example
filter(query, trigram_similarity(name, "geoff") > 0.4)
"""
use Ash.Query.Function, name: :trigram_similarity
def args, do: [[:string, :string]]
end