How do we support FULL JOIN on PostGIS types?

Поиск
Список
Период
Сортировка
От Darafei "Komяpa" Praliaskouski
Тема How do we support FULL JOIN on PostGIS types?
Дата
Msg-id CAC8Q8tJKy=hitYzSBYpKARJFDE92BO+ObGLBQNa4c4kxD=NdTA@mail.gmail.com
обсуждение исходный текст
Ответы Re: How do we support FULL JOIN on PostGIS types?  (Darafei "Komяpa" Praliaskouski <me@komzpa.net>)
Список pgsql-hackers
Дерево обсуждения
Hi!

Greetings from OSGeo Code sprint in Minneapolis :)

We're trying to make FULL JOIN on equality of geometry and can't figure out why it doesn't work.

Here's reproducer, it works on bytea but not on PostGIS geometry throwing out 

ERROR: FULL JOIN is only supported with merge-joinable or hash-joinable join conditions


We already have a btree opclass with equality: 
 
We also have hash equality opclass:

Reading through Postgres documentation I can't figure out what else shall we do for this join to work. How do we make it work?

--
Darafei Praliaskouski

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

Предыдущее
От: Anthony Nowocien
Дата:
Сообщение: Re: dropdb --force
Следующее
От: Albert Cervera i Areny
Дата:
Сообщение: Re: PSA: New intel MDS vulnerability mitigations cause measurable slowdown