Re: [POC] Allow flattening of subquery with a link to upper query

From: Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>
To: Zhihong Yu <zyu(at)yugabyte(dot)com>, PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: [POC] Allow flattening of subquery with a link to upper query
Date: 2022-10-05 11:38:10
Message-ID: 35c8a3e8-d080-dfa8-2be3-cf5fe702010a@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 5/10/2022 02:45, Zhihong Yu wrote:
> Hi,
> For contain_placeholders():
>
> +   if (IsA(node, Query))
> +       return query_tree_walker((Query *) node, contain_placeholders,
> context, 0);
> +   else if (IsA(node, PlaceHolderVar))
Fixed
>
> The `else` is not needed.
>
> For correlated_t struct, it would be better if the fields have comments.
Ok, I've added some comments.
>
> +                    * (for grouping, as an example). So, revert its
> status to
> +                    * a full valued entry.
>
> full valued -> fully valued
Fixed

--
regards,
Andrey Lepikhov
Postgres Professional

Attachment Content-Type Size
v3-0001-Transform-correlated-subquery-of-type-N-J-1-into-ord.patch text/plain 51.6 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message vignesh C 2022-10-05 12:05:38 Re: Miscellaneous tab completion issue fixes
Previous Message Alvaro Herrera 2022-10-05 10:55:23 Re: [BUG] parenting a PK constraint to a self-FK one (Was: Self FK oddity when attaching a partition)