Update documents in an Infino table
infino_update_documentsReplace documents matching a SQL predicate with new rows, one-for-one, using local embeddings when vectors are omitted.
Instructions
Replace the rows matching a SQL predicate with new documents, 1:1; the number of matched rows must equal the number of replacement documents. As with add, a row that omits its vector has it embedded from the text column (local model, no API key). Requires durable storage (not memory://).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table to update. | |
| documents | Yes | Replacement rows, as JSON objects keyed by column name (one per matched row). | |
| predicate | Yes | SQL predicate selecting the rows to replace, e.g. "status = 'draft'". |