Pavel Stehule <pavel.stehule@xxxxxxxxx> writes: > Some errors like this, but not this can be detected by plpgsql_check > https://github.com/okbob/plpgsql_check - probably the heuristic for type > check is not complete. STRICTMULTIASSIGNMENT would detect most cases of this, except that the condition is checked too late. We'd need to count the fields *before* trying to assign values, not after. In the meantime, it does seem like the docs could be more explicit about this, and perhaps give an example showing the (x).* solution. regards, tom lane
