On Wed, Dec 1, 2021 at 12:44 PM Jenda Krynicky <Jenda@krynicky.cz> wrote:
How's that a variable for gawd's sake? It's a column name too! A column name in the definition of the resulting table.
The columns of the returns table are provided to the function as variables so that one can write:
output_column1 := 'value';
output_column2 := 'value';
return;
Instead of having to do:
return (output_column1, output_column2);
Right. Because lowercasing everything I write and then comparing it case sensitively to the names of database objects makes a lot of sense. I mean who would want to use capital letters in names of objects in the first place?
Fair point, but you're not going to get much sympathy for not knowing the rules of the tool that you are using and the choices you've made regarding them. I agree that your quoting everything has merit, but don't go complaining that when you forgot the quotes the system tells you the name is no longer found.