Re: FULL JOIN is only supported with merge-joinable join conditions - Mailing list pgsql-general

From hx.li
Subject Re: FULL JOIN is only supported with merge-joinable join conditions
Date
Msg-id hi3laa$2j6b$1@news.hub.org
Whole thread Raw
In response to FULL JOIN is only supported with merge-joinable join conditions  ("hx.li" <fly2nn@126.com>)
Responses Re: FULL JOIN is only supported with merge-joinable join conditions
List pgsql-general
> It's an implementation restriction.  If the clauses aren't mergejoinable
> there's no very practical way to keep track of which inner-side rows
> have had a match.


If we could consider it is equivalent transformation as follow?

select * from t_1 full outer join t_3 on t_1.a=1;
and
select * from t_1 full outer join t_3 on true where t_1.a=1;

If we could transform RestrictInfo into the where-clause, maybe it right.

TEST=# select * from t_1 full outer join t_3 on true where t_1.a=1;
 A | A
---+---
 1 | 1
 1 | 3
(2 rows)



pgsql-general by date:

Previous
From: Richard Broersma
Date:
Subject: Re: Is there any different for foreign key to be serial instead of integer
Next
From: Tom Lane
Date:
Subject: Re: FULL JOIN is only supported with merge-joinable join conditions