Re: Making Vars outer-join aware

From: "Finnerty, Jim" <jfinnert(at)amazon(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Making Vars outer-join aware
Date: 2022-07-01 20:19:48
Message-ID: A6EE2336-84B3-4FC9-A452-519C097A5536@amazon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom, two quick questions before attempting to read the patch:

Given that views are represented in a parsed representation, does anything need to happen to the Vars inside a view when that view is outer-joined to?

If an outer join is converted to an inner join, must this information get propagated to all the affected Vars, potentially across query block levels?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2022-07-01 20:29:44 Re: EINTR in ftruncate()
Previous Message Andres Freund 2022-07-01 20:14:23 Re: Is RecoveryConflictInterrupt() entirely safe in a signal handler?