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.

Examples

Text search

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

Basic normalization

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

Full normalization

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

Websearch

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