On Wed, Dec 1, 2021 at 1:04 PM Jenda Krynicky <Jenda@krynicky.cz> wrote:
I did not create the table and I did not forget the quotes. I removed them in one of many attempts to appease PostgreSQL. I've already learned about those braindead rules.
Nothing is perfect, especially something that started decades ago and has to be concerned about ongoing compatibility. The best part is you got some clarification (that the RETURNS column is indeed the main cause of the issue) quickly from two different people and eventually came across the #variable_conflict hack that at least here is the least invasive solution to what is arguably a deficiency in the interaction between SQL and pl/pgsql. They happen, again nothing is perfect.