Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Wed, Dec 22, 2021 at 6:27 PM Bryn Llewellyn <bryn@xxxxxxxxxxxx> wrote:

  update t set t.v = p.v where t.k = p.k;

At run-time, p() terminates with an obscurely worded error:

42703: column "t" of relation "t" does not exist.

"set t.v" is simply invalid SQL and the error has nothing with this discussion.

https://www.postgresql.org/docs/current/sql-update.html

David J.