[postgis-tickets] [PostGIS] #4394: FULL JOIN on geometry not supported

[PostGIS]

#4394: FULL JOIN on geometry not supported
---------------------+---------------------------
 Reporter:  komzpa   |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 2.5.3
Component:  postgis  |    Version:  2.4.x
 Keywords:           |
---------------------+---------------------------
 {{{
 root=# create table aaa  as (select 'POINT(0 0)':: geometry as geom);
 SELECT 1
 root=# select * from aaa a full join aaa b on a.geom = b.geom;
 ERROR:  FULL JOIN is only supported with merge-joinable or hash-joinable
 join conditions
 root=# select * from aaa a full join aaa b on a.geom::bytea =
 b.geom::bytea;
                     geom                    |                    geom
 --------------------------------------------+--------------------------------------------
  010100000000000000000000000000000000000000 |
 010100000000000000000000000000000000000000
 (1 row)

 }}}

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4394>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.