Re: pl/pgsql feature request: shorthand for argument and local variable references

On Thu, Jan 6, 2022, at 10:05, Julien Rouhaud wrote:

> I agree, but on the other hand I don't see how defining a top level block

> alias identical for every single plpgsql function would really make sense.

> Not every function has a very long name and would benefit from it, and no one

> can really assume that e.g. "root" or whatever configured name won't be used in

> any plpgsql function on that database or cluster.  So while having some global

> configuration infrastructure can be useful I still don't think that it could be

> used for this purpose.

How about using the existing reserved keyword "in" followed by "." (dot) and then the function parameter name?

This idea is based on the assumption "in." would always be a syntax error everywhere in both SQL and PL/pgSQL,

so if we would introduce such a syntax, no existing code could be affected, except currently invalid code.

I wouldn't mind using "in." to refer to IN/OUT/INOUT parameters and not only IN ones, it's a minor confusion that could be explained in the docs.

Also, "out." wouldn't work, since "out" is not a reserved keyword.

/Joel