| From: | Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> |
|---|---|
| To: | Richard Guo <guofenglinux(at)gmail(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: [POC] Allow flattening of subquery with a link to upper query |
| Date: | 2022-10-04 05:35:30 |
| Message-ID: | 400831f1-b038-6df6-8251-3e6879453462@postgrespro.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 9/13/22 16:40, Andrey Lepikhov wrote:
> On 5/9/2022 12:22, Richard Guo wrote:
>> On Fri, Sep 2, 2022 at 7:09 PM Andrey Lepikhov
>> <a(dot)lepikhov(at)postgrespro(dot)ru <mailto:a(dot)lepikhov(at)postgrespro(dot)ru>> wrote:
> To resolve both issues, lower outer join passes through pull_sublinks_*
> into flattening routine (see attachment).
> I've added these cases into subselect.sql
In attachment - new version of the patch, rebased onto current master.
--
Regards
Andrey Lepikhov
Postgres Professional
| Attachment | Content-Type | Size |
|---|---|---|
| v2-0001-Transform-correlated-subquery-of-type-N-J-1-into-ord.patch | text/x-patch | 50.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bharath Rupireddy | 2022-10-04 05:36:15 | Use XLogFromFileName() in pg_resetwal to parse position from WAL file |
| Previous Message | Peter Smith | 2022-10-04 05:20:36 | Re: GUC tables - use designated initializers |