Kotlin: Match a string

Only relevant for text and tsvector columns. Match only rows where column matches the query string in query.

For more information, see Postgres full text search.

Parameters

• column

  (Required)

  The text or tsvector column to filter on

• query

  (Required)

  The query text to match with

• textSearchType

  (Optional)

  The type of text search to use. Defaults to `TextSearchType.NONE`.

• config

  (Optional)

  The text search configuration to use.

Examples

Text search

supabase.from("quotes").select(columns = Columns.list("catchphrase")) \{
    filter \{
       textSearch(column = "catchphrase", query = "'fat' & 'cat'", config = "english", type = TextSearchType.YOUR_TYPE)
    \}
\}

Search multiple columns

supabase.from("quotes").select(columns = Columns.list("catchphrase")) \{
    filter \{
      or \{
        textSearch(column = "catchphrase", query = "'fat' & 'cat'", config = "english", type = TextSearchType.YOUR_TYPE)
        textSearch(column = "author", query = "'fat' & 'cat'", config = "english", type = TextSearchType.YOUR_TYPE)
      \}
    \}
\}

Basic normalization

supabase.from("quotes").select(columns = Columns.list("catchphrase")) \{
    filter \{
       textSearch(column = "catchphrase", query = "'fat' & 'cat'", config = "english", type = TextSearchType.PLAINTO)
    \}
\}

Full normalization

supabase.from("quotes").select(columns = Columns.list("catchphrase")) \{
    filter \{
       textSearch(column = "catchphrase", query = "'fat' & 'cat'", config = "english", type = TextSearchType.PHRASETO)
    \}
\}

Websearch

supabase.from("quotes").select(columns = Columns.list("catchphrase")) \{
    filter \{
       textSearch(column = "catchphrase", query = "'fat' & 'cat'", config = "english", type = TextSearchType.WEBSEARCH)
    \}
\}