Archiwizowane June, 2014

On 18th of June, Tom Lane committed patch: Implement UPDATE tab SET (col1,col2,...) = (SELECT ...), ... This SQL-standard feature allows a sub-SELECT yielding multiple columns (but only one row) to be used to compute the new values of several columns to be updated. ...

A colleague recently let me know that anonymization in explain.depesz.com doesn't handle CTE names. For example, in plan: ...