update_rows
Update rows in a PostgreSQL table with mandatory filters and values. Supports optional optimistic concurrency and commit validation for data integrity.
Instructions
Update typed values with mandatory filters, optimistic predicates, and commit guards
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| where | Yes | Mandatory structured target filter | |
| values | Yes | Columns and bound replacement values | |
| returning | No | Columns returned after commit validation | |
| concurrency | No | Optional optimistic concurrency predicates | |
| schema_name | Yes | Exact schema name | |
| expected_rows | No | Optional exact affected row count | |
| relation_name | Yes | Exact table name | |
| max_affected_rows | No | Hard mutation ceiling |