Re: FULL JOIN is only supported with merge-joinable join conditions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "hx(dot)li" <fly2nn(at)126(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: FULL JOIN is only supported with merge-joinable join conditions
Date: 2010-01-07 04:23:31
Message-ID: 8601.1262838211@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"hx.li" <fly2nn(at)126(dot)com> writes:
> 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;

Those are not equivalent.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-01-07 04:36:39 Re: Is there any different for foreign key to be serial instead of integer
Previous Message Richard Broersma 2010-01-07 04:08:54 Re: Is there any different for foreign key to be serial instead of integer