From: | Darafei "Komяpa" Praliaskouski <me(at)komzpa(dot)net> |
---|---|
To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | How do we support FULL JOIN on PostGIS types? |
Date: | 2019-05-16 16:05:53 |
Message-ID: | CAC8Q8tJKy=hitYzSBYpKARJFDE92BO+ObGLBQNa4c4kxD=NdTA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
https://trac.osgeo.org/postgis/ticket/4394
We already have a btree opclass with equality:
https://github.com/postgis/postgis/blob/svn-trunk/postgis/postgis.sql.in#L420
We also have hash equality opclass:
https://github.com/postgis/postgis/blob/svn-trunk/postgis/postgis.sql.in#L440
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
Support me: http://patreon.com/komzpa
From | Date | Subject | |
---|---|---|---|
Next Message | Albert Cervera i Areny | 2019-05-16 16:24:40 | Re: PSA: New intel MDS vulnerability mitigations cause measurable slowdown |
Previous Message | Anthony Nowocien | 2019-05-16 15:31:18 | Re: dropdb --force |