Update returning postgresql

Concurrency-wise, I'm not sure what the behavior would be, TBH; best I can do is point you at the relevant docs. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 3 years, 2 months ago. Active 3 years, 2 months ago. Viewed times. Is there a more elegant solution to this? SuperTron SuperTron 4, 6 6 gold badges 33 33 silver badges 60 60 bronze badges. I find stored procedures to be hard to maintain long term. Figured I'd ask here before going that route : — SuperTron. Add a comment.

Active Oldest Votes. Seems like the concurrency aspect of this is pretty complex. I've redesigned that bit to use Redis to keep track of the remaining count instead. Thanks for the doc link! Sign up or log in Sign up using Google. A substitute name for the target table. When an alias is provided, it completely hides the actual name of the table. The name of a column in table. The column name can be qualified with a subfield name or array subscript, if needed.

An expression to assign to the column. The expression can use the old values of this and other columns in the table. Set the column to its default value which will be NULL if no specific default expression has been assigned to it. A list of table expressions, allowing columns from other tables to appear in the WHERE condition and the update expressions. An expression that returns a value of type boolean.

Only rows for which this expression returns true will be updated. The row to be updated is the one most recently fetched from this cursor. The expression can use any column names of the table or table s listed in FROM. The count is the number of rows updated. If count is 0, no rows matched the condition this is not considered an error. When using FROM you should ensure that the join produces at most one output row for each row to be modified.

In other words, a target row shouldn't join to more than one row from the other table s. If it does, then only one of the join rows will be used to update the target row, but which one will be used is not readily predictable. Because of this indeterminacy, referencing other tables only within sub-selects is safer, though often harder to read and slower than using a join.

Change the word Drama to Dramatic in the column kind of the table films :.