Postgres Pro
Downloads
Home   >   mailing lists

How do we support FULL JOIN on PostGIS types? - Mailing list pgsql-hackers

From Darafei "Komяpa" Praliaskouski
Subject How do we support FULL JOIN on PostGIS types?
Date
Msg-id CAC8Q8tJKy=hitYzSBYpKARJFDE92BO+ObGLBQNa4c4kxD=NdTA@mail.gmail.com
Whole thread Raw
Responses Re: How do we support FULL JOIN on PostGIS types?  (Darafei "Komяpa" Praliaskouski <me@komzpa.net>)
List pgsql-hackers
Tree view
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 by date:

Previous
From: Anthony Nowocien
Date:
Subject: Re: dropdb --force
Next
From: Albert Cervera i Areny
Date:
Subject: Re: PSA: New intel MDS vulnerability mitigations cause measurable slowdown