ash_postgres/lib/functions/trigram_similarity.ex

18 lines
573 B
Elixir
Raw Permalink Normal View History

defmodule AshPostgres.Functions.TrigramSimilarity do
@moduledoc """
2022-08-24 11:56:46 +12:00
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
2021-01-24 16:45:15 +13:00
def args, do: [[:string, :string]]
end