C#: Match a string

Finds all rows whose tsvector value on the stated column matches to_tsquery(query).

Examples

Text search

var result = await supabase.From<Quote>()
  .Select(x => x.Catchphrase)
  .Filter(x => x.Catchphrase, Operator.FTS, new FullTextSearchConfig("'fat' & 'cat", "english"))
  .Get();

Basic normalization

var result = await supabase.From<Quote>()
  .Select(x => x.Catchphrase)
  .Filter(x => x.Catchphrase, Operator.PLFTS, new FullTextSearchConfig("'fat' & 'cat", "english"))
  .Get();

Full normalization

var result = await supabase.From<Quote>()
  .Select(x => x.Catchphrase)
  .Filter(x => x.Catchphrase, Operator.PHFTS, new FullTextSearchConfig("'fat' & 'cat", "english"))
  .Get();

Websearch

var result = await supabase.From<Quote>()
  .Select(x => x.Catchphrase)
  .Filter(x => x.Catchphrase, Operator.WFTS, new FullTextSearchConfig("'fat' & 'cat", "english"))
  .Get();