Postgres Pro
Downloads
Home   >   mailing lists

What does "merge-joinable join conditions" mean ???? - Mailing list pgsql-sql

From Dean Gibson (DB Administrator)
Subject What does "merge-joinable join conditions" mean ????
Date
Msg-id 43CAAFA6.6050001@ultimeth.com
Whole thread Raw
Responses Re: What does "merge-joinable join conditions" mean ????  (Michael Fuhr <mike@fuhr.org>)
Re: What does "merge-joinable join conditions" mean ????  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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 #@!! it meant.  
Using 8.0.4 on FC1;  willing to upgrade (PostgreSQL, not FC1) IF it 
would fix the problem.

-- Dean

pgsql-sql by date:

Previous
From: Alexandre Gonçalves Jacarandá
Date:
Subject: Re: select and as doubt
Next
From: Michael Fuhr
Date:
Subject: Re: What does "merge-joinable join conditions" mean ????