On 7/7/24 07:53, Pavel Stehule wrote:
ne 7. 7. 2024 v 16:48 odesílatel Adrian Klaver
<adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> 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.
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@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
