Full text search
full_text_searchRank a text column's documents against a full-text query using PostgreSQL's built-in tsvector/tsquery with web-search syntax support, returning matched rows and rank scores.
Instructions
Rank a text column's documents against a full-text query using PostgreSQL's built-in tsvector/tsquery. The query accepts web-search syntax (quoted phrases, or, - exclusion). Returns a list of objects with the matched row's primary key columns plus rank (ts_rank score, higher = better match).
Example: full_text_search(schema='public', table='articles', column='body', search_query='"new york" OR -draft')
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| table | Yes | ||
| column | Yes | ||
| config | No | english | |
| schema | Yes | ||
| database | No | Optional: target a configured secondary (read-only) database by name; omit for the primary. Call list_databases to see the configured ids. | |
| search_query | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |