On 7/7/24 07:53, Pavel Stehule wrote: > > > ne 7. 7. 2024 v 16:48 odesílatel Adrian Klaver > <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> napsal: > > On 7/7/24 07:42, Pavel Stehule wrote: > > I'm not sure why there's a warning about using an alias. > 43.3.1 says > > to use them for improved readability. > > > > > > it is obsolete - aliases were used when Postgres doesn't support > named > > arguments. > > Is that was what it was complaining about or the fact they where > declared and never used? > > > I am not sure if I understand the question. My reply was related to > generic usage of aliases.
The conversation was:
Mike Nolan
"I'm not sure why there's a warning about using an alias. 43.3.1 says to use them for improved readability."
Pavel Stehule
"it is obsolete - aliases were used when Postgres doesn't support named arguments."
I was just trying to confirm that the warning was not for ALIAS being declared. That it was for what you state below.
ok
> > Report from plpgsql_check was correct - and related variables were not > used. > > > > > > I don't know any good reason why one variable can use more than > one name. > > Section 43.3.2. ALIAS provides the pros/cons. > > > > > There can be an exception when argument names are very long, but > > generally they are not used. > > > > > > > > Mike Nolan > > > > -- > Adrian Klaver > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com> >