Vector range search
vector_range_searchRetrieve all rows within a specified distance of a query vector for threshold-based similarity search, ideal for deduplication and clustering pre-passes.
Instructions
Return every row within max_distance of a query vector (a threshold-based query rather than top-k). Useful for de-dup, similarity gating, and clustering pre-passes. Still ordered by distance and capped at limit to avoid pulling huge result sets. Reports available=false if the pgvector extension is not installed.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| table | Yes | ||
| column | Yes | ||
| metric | No | l2 | |
| 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. | |
| max_distance | Yes | ||
| query_vector | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| matches | Yes | ||
| available | Yes |