Re: Making the subquery alias optional in the FROM clause

Поиск
Список
Период
Сортировка
От Zhihong Yu
Тема Re: Making the subquery alias optional in the FROM clause
Дата
Msg-id CALNJ-vRERENLhF0aKRX5RLHuk1JwYshFeXQB=wXpDxgHmicXXg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Making the subquery alias optional in the FROM clause  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Список pgsql-hackers


On Sat, Jul 9, 2022 at 5:18 AM Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
On Sat, 9 Jul 2022 at 12:24, Zhihong Yu <zyu@yugabyte.com> wrote:
>
>  It seems the code would be more readable if you keep the assignment in else block below:
>
> +                   else if (rte->rtekind == RTE_SUBQUERY ||
> +                            rte->rtekind == RTE_VALUES)
>                         continue;
> -                   rtename = rte->join_using_alias->aliasname;
>                 }
> -               else
> -                   rtename = rte->eref->aliasname;
>
> because rtename would be assigned in the `rte->rtekind == RTE_JOIN` case.
>

But then it would need 2 else blocks, one inside the rte->alias ==
NULL block, for when rtekind is not RTE_JOIN, RTE_SUBQUERY or
RTE_VALUES, and another after the block, for when rte->alias != NULL.
I find it more readable this way.

Regards,
Dean
 
Hi, Dean:
Thanks for the explanation.

I should have looked closer :-) 

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Graham Leggett
Дата:
Сообщение: Re: [PATCH] Log details for client certificate failures
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: automatically generating node support functions