.textSearch()

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

Examples#

Text search#

1final data = await supabase
2  .from('quotes')
3  .select('catchphrase')
4  .textSearch('catchphrase', "'fat' & 'cat'", 
5    config: 'english' 
6  );

Basic normalization#

Uses PostgreSQL's plainto_tsquery function.

1final data = await supabase
2  .from('quotes')
3  .select('catchphrase')
4  .textSearch('catchphrase', "'fat' & 'cat'",  
5    type: TextSearchType.plain,
6    config: 'english' 
7  );

Full normalization#

Uses PostgreSQL's phraseto_tsquery function.

1final data = await supabase
2  .from('quotes')
3  .select('catchphrase')
4  .textSearch('catchphrase', "'fat' & 'cat'",  
5    type: TextSearchType.phrase,
6    config: 'english' 
7  );

Full normalization#

Uses PostgreSQL's websearch_to_tsquery function. This function will never raise syntax errors, which makes it possible to use raw user-supplied input for search, and can be used with advanced operators.

• unquoted text: text not inside quote marks will be converted to terms separated by & operators, as if processed by plainto_tsquery.
• "quoted text": text inside quote marks will be converted to terms separated by <-> operators, as if processed by phraseto_tsquery.
• OR: the word “or” will be converted to the | operator.
• -: a dash will be converted to the ! operator.

1final data = await supabase
2  .from('quotes')
3  .select('catchphrase')
4  .textSearch('catchphrase', "'fat or cat'",  
5    type: TextSearchType.websearch,
6    config: 'english'
7  );