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 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
