summaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/update.sgml
AgeCommit message (Expand)Author
13 daysdoc: Updates for RETURNING OLD/NEW.Dean Rasheed
2025-01-16Add OLD/NEW support to RETURNING in DML queries.Dean Rasheed
2024-07-25Doc: fix misleading syntax synopses for targetlists.Tom Lane
2024-04-07Doc: show how to get the equivalent of LIMIT for UPDATE/DELETE.Tom Lane
2022-03-29doc: Make UPDATE FROM examples consistentDaniel Gustafsson
2022-03-20Enforce foreign key correctly during cross-partition updatesAlvaro Herrera
2020-05-11Doc: fix "Unresolved ID reference" warnings, clean up man page cross-refs.Tom Lane
2020-03-31doc: adjust UPDATE/DELETE's FROM/USING to match SELECT's FROMBruce Momjian
2020-03-31Fix INSERT OVERRIDING USER VALUE behaviorPeter Eisentraut
2019-03-10Fix documentation on partitioning vs. foreign tablesAlvaro Herrera
2018-04-06Allow insert and update tuple routing and COPY for foreign tables.Robert Haas
2018-01-19Allow UPDATE to move rows between partitions.Robert Haas
2017-11-23Convert documentation to DocBook XMLPeter Eisentraut
2017-10-20Convert SGML IDs to lower casePeter Eisentraut
2017-10-17Don't use SGML empty tagsPeter Eisentraut
2017-10-10Use lower-case SGML attribute valuesPeter Eisentraut
2016-12-13doc: Improve documentation related to table partitioning feature.Robert Haas
2016-11-22Improve handling of "UPDATE ... SET (column_list) = row_constructor".Tom Lane
2016-07-08Docs: improve examples about not repeating table name in UPDATE ... SET.Tom Lane
2014-06-18Implement UPDATE tab SET (col1,col2,...) = (SELECT ...), ...Tom Lane
2014-02-24doc: Improve DocBook XML validityPeter Eisentraut
2012-09-17Provide adequate documentation of the "table_name *" notation.Tom Lane
2012-06-21Make placeholders in SQL command help more consistent and precisePeter Eisentraut
2011-10-10Document DELETE/UPDATE command tag behavior when triggers are involved.Robert Haas
2011-08-07Fix a whitespace issue with the man pagesPeter Eisentraut
2010-10-15Allow WITH clauses to be attached to INSERT, UPDATE, DELETE statements.Tom Lane
2010-09-20Remove cvs keywords from all files.Magnus Hagander
2010-04-03Remove unnecessary xref endterm attributes and title idsPeter Eisentraut
2009-09-19Make the placeholder naming in the synopses of the SQL help more consistentPeter Eisentraut
2009-01-22Support column-level privileges, as required by SQL standard.Tom Lane
2008-11-16Modify UPDATE/DELETE WHERE CURRENT OF to use the FOR UPDATE infrastructure toTom Lane
2008-11-14Set SQL man pages to be section 7 by default, and only transform them toPeter Eisentraut
2008-02-15Allow AS to be omitted when specifying an output column name in SELECTTom Lane
2007-11-28spell checker runPeter Eisentraut
2007-06-11Support UPDATE/DELETE WHERE CURRENT OF cursor_name, per SQL standard.Tom Lane
2007-02-01Consistenly use colons before '<programlisting>' blocks, whereBruce Momjian
2007-01-31Update reference documentation on may/can/might:Bruce Momjian
2006-09-16Remove emacs info from footer of SGML files.Bruce Momjian
2006-09-03Code review for UPDATE SET (columnlist) patch. Make it handle as muchTom Lane
2006-09-02Add UPDATE tab SET ROW (col, ...) = (val, ...) for updatingBruce Momjian
2006-08-12Add INSERT/UPDATE/DELETE RETURNING, with basic docs and regression tests.Tom Lane
2006-03-08Remove somebody's flight of fancy about an UPDATE with ORDER BY and LIMIT.Tom Lane
2006-01-22Improve note about not using the target table name in the SET clause.Tom Lane
2006-01-22Allow an optional alias for the target table to be specified for UPDATENeil Conway
2006-01-19Doc patch that adds an example of a correllated UPDATE.Bruce Momjian
2005-10-12Fix spelling error, per Michael Fuhr.Tom Lane
2005-01-09Some more small improvements in response to 7.4 interactive docs comments.Tom Lane
2005-01-04More minor updates and copy-editing.Tom Lane
2004-08-08Included is an example of using savepoints in a non-trivial example.Bruce Momjian
2004-06-09Support assignment to subfields of composite columns in UPDATE and INSERT.Tom Lane