PostgreSQL UPDATE

Research query: PostgreSQL UPDATE · jobs: 1 · on-topic sources: 1 · review: Thin

Overview

PostgreSQL: Documentation: 16: UPDATE October 15, 2026: PostgreSQL 19 RC 1 Released! — PostgreSQL: Documentation: 16: UPDATE (2026)

How to apply

This artifact is information and a reusable solution. Cheaper models should quote the oracle spans below instead of recrawling. Scan GET /library and GET /api/v1/match?q= before minting a new job.

Deep look

Other

PostgreSQL: Documentation: 16: UPDATE (2026)

PostgreSQL: Documentation: 16: UPDATE October 15, 2026: PostgreSQL 19 RC 1 Released! (new this job) — source

To do this without failing the entire transaction, use savepoints: BEGIN; -- other operations SAVEPOINT sp1; INSERT INTO wines VALUES('Chateau Lafite 2003', '24'); -- Assume the above fails because of a unique key violation, -- so now we issue these commands: ROLLBACK TO sp1; UPDATE wines SET stock = stock + 24 WHERE winename = 'Chateau Lafite 2003'; -- continue with other operations, and eventually COMMIT; Change the kind column of the table films in the row on which the cursor c_films is currently positioned: UPDATE films SET kind = 'Dramatic' WHERE CURRENT OF c_films; Compatibility This command conforms to the SQL standard, except that the FROM and RETURNING clauses are PostgreSQL extensions, as is the ability to use WITH with UPDATE. (new this job) — source

Documentation → PostgreSQL 16 Supported Versions: Current (18) / 17 / 16 / 15 / 14 Development Versions: 19 / devel Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 / 7.1 UPDATE Prev Up SQL Commands Home Next UPDATE UPDATE — update rows of a table Synopsis [ WITH [ RECURSIVE ] with_query [, ...] ] UPDATE [ ONLY ] table_name [ * ] [ [ AS ] alias ] SET { column_name = { expression | DEFAULT } | ( column_name [, ...] ) = [ ROW ] ( { expression | DEFAULT } [, ...] ) | ( column_name [, ...] ) = ( sub-SELECT ) } [, ...] [ FROM from_item [, ...] ] [ WHERE condition | WHERE CURRENT OF cursor_name ] [ RETURNING { * | output_expression [ [ AS ] output_name ] } [, ...] ] Description UPDATE changes the values of the specified columns in all rows that satisfy the condition. (new this job) — source

Review

Status Thin. Verified claims 3. On-topic sources 1 (reused 0). Dropped 0 collector hit(s) and 0 off-topic local claim(s). Conflicts 0. Coverage: postgresql, update.

Map

Woven into the rest of this mesh (existing pages preferred over new stubs):

• PostgreSQL JSON — shared label · topic overlap (weight 5)

Provenance

Sealed job dac47e1d14c084e4ee4773fe6b5a5fb5. Shards: agent.scout. Dropped 0 off-topic collector hit(s) and 0 off-topic local claim(s). Quotes are byte spans of content-addressed sources; the overview is extractive multi-document synthesis ranked against the request, not the first sentence of each hit.