ne 7. 7. 2024 v 17:00 odesÃlatel Adrian Klaver <adrian.kla...@aklaver.com> napsal:
> On 7/7/24 07:53, Pavel Stehule wrote: > > > > > > ne 7. 7. 2024 v 16:48 odesÃlatel Adrian Klaver > > <adrian.kla...@aklaver.com <mailto:adrian.kla...@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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > >
