#YUM UPDATE POSTGRESQL UPDATE#

Optionally, * can be specified after the table name to explicitly indicate that descendant tables are included. If ONLY is not specified, matching rows are also updated in any tables inheriting from the named table. If ONLY is specified before the table name, matching rows are updated in the named table only. The name (optionally schema-qualified) of the table to update.

#YUM UPDATE POSTGRESQL UPDATE#

The WITH clause allows you to specify one or more subqueries that can be referenced by name in the UPDATE query. You must also have the SELECT privilege on any column whose values are read in the expressions or condition. You must have the UPDATE privilege on the table, or at least on the column(s) that are listed to be updated. The syntax of the RETURNING list is identical to that of the output list of SELECT. The new (post-update) values of the table's columns are used.

Any expression using the table's columns, and/or columns of other tables mentioned in FROM, can be computed. The optional RETURNING clause causes UPDATE to compute and return value(s) based on each row actually updated. Which technique is more appropriate depends on the specific circumstances. There are two ways to modify a table using information contained in other tables in the database: using sub-selects, or specifying additional tables in the FROM clause. Only the columns to be modified need be mentioned in the SET clause columns not explicitly modified retain their previous values. UPDATE changes the values of the specified columns in all rows that satisfy the condition.

Yum update postgresql