What does "merge-joinable join conditions" mean ????

From: "Dean Gibson (DB Administrator)" <postgresql4(at)ultimeth(dot)com>
To: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: What does "merge-joinable join conditions" mean ????
Date: 2006-01-15 20:25:10
Message-ID: 43CAAFA6.6050001@ultimeth.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I have a FULL JOIN between two simple tables, and am getting the message
" Query failed: ERROR: FULL JOIN is only supported with merge-joinable
join conditions"

I'd be glad to fix this in my query if I knew what the #(at)!! it meant.
Using 8.0.4 on FC1; willing to upgrade (PostgreSQL, not FC1) IF it
would fix the problem.

-- Dean

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2006-01-15 21:54:48 Re: What does "merge-joinable join conditions" mean ????
Previous Message Alexandre Gonçalves Jacarandá 2006-01-15 14:59:48 Re: select and as doubt