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

Поиск
Список
Период
Сортировка
От Dean Gibson (DB Administrator)
Тема What does "merge-joinable join conditions" mean ????
Дата
Msg-id 43CAAFA6.6050001@ultimeth.com
обсуждение исходный текст
Ответы 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>)
Список 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 #@!! it meant.  
Using 8.0.4 on FC1;  willing to upgrade (PostgreSQL, not FC1) IF it 
would fix the problem.

-- Dean



В списке pgsql-sql по дате отправления:

Предыдущее
От: Alexandre Gonçalves Jacarandá
Дата:
Сообщение: Re: select and as doubt
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: What does "merge-joinable join conditions" mean ????