ne 7. 7. 2024 v 17:00 odesÃlatel Adrian Klaver <[email protected]> napsal:
> On 7/7/24 07:53, Pavel Stehule wrote: > > > > > > ne 7. 7. 2024 v 16:48 odesÃlatel Adrian Klaver > > <[email protected] <mailto:[email protected]>> 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 > > [email protected] <mailto:[email protected]> > > > > -- > Adrian Klaver > [email protected] > >
