| 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: | Whole Thread | Raw Message | 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 |