Hi! I have solved it.
On 30.12.2024 11:24, Alena Rybakina wrote:
Hi! Thank you for your interest to this subject!
On 27.12.2024 15:53, Ilia Evdokimov wrote:
Hi Alena,
Thank you for your work on subqueries with JOIN.
Have you considered the scenario where in subquery includes a qual
like (t
Hi! Thank you for your interest to this subject!
On 27.12.2024 15:53, Ilia Evdokimov wrote:
Hi Alena,
Thank you for your work on subqueries with JOIN.
Have you considered the scenario where in subquery includes a qual
like (tc.aid = 1)? When I tried executing those queries I receive
differen
Hi Alena,
Thank you for your work on subqueries with JOIN.
Have you considered the scenario where in subquery includes a qual like
(tc.aid = 1)? When I tried executing those queries I receive different
results. In my opinion, to prevent this, we should add filters for such
quals within the lo
On 24.12.2024 13:25, Ranier Vilela wrote:
Hi Alena.
Em ter., 24 de dez. de 2024 às 01:44, Alena Rybakina
escreveu:
Hi, hackers!
I found one pull-up that works if the inner join condition is
written through the where condition,
|create temp table ta (id int primary key, val
Hi Alena.
Em ter., 24 de dez. de 2024 às 01:44, Alena Rybakina <
a.rybak...@postgrespro.ru> escreveu:
> Hi, hackers!
>
> I found one pull-up that works if the inner join condition is written
> through the where condition,
>
> create temp table ta (id int primary key, val int);
> insert into ta va
Hi, hackers!
I found one pull-up that works if the inner join condition is written
through the where condition,
|create temp table ta (id int primary key, val int); insert into ta
values(1,1); insert into ta values(2,2); ||insert into ta values(3,3);|
|create temp table tb (id int primary k
