* Harco de Hilster ([EMAIL PROTECTED]) wrote:
> ERROR: FULL JOIN is only supported with merge-joinable join conditions
I'm not a big fan of that error either, honestly.
> select *
> from A
> full outer join B on A.f1 = B.f1 and ((A.ExpTime IS NULL AND B.ExpTime
> IS NULL) OR (A.ModTime <= B.E
Martijn van Oosterhout writes:
> I think the reason it hasn't been done for general join conditions is
> because we havn't thought of an efficient algorithm.
Right, it's keeping track of the unmatched right-hand rows that's a
problem.
> However, I wonder if youre case couldn't be handled with a
On Mon, Mar 13, 2006 at 11:02:35AM +0100, Harco de Hilster wrote:
> Hi all,
>
> I am porting my application from Ingres to Postgres, and I have the
> following problem. I am not sure if this is a known limitation of
> Postgresql or a bug. My code works under Ingres but fails in Postgres
> with the
