[postgis-tickets] [PostGIS] #5546: ERROR: operator is not unique: topogeometry <> topogeometry

PostGIS trac at osgeo.org
Fri Sep 22 03:07:55 PDT 2023


#5546: ERROR:  operator is not unique: topogeometry <> topogeometry
-----------------------+---------------------------
  Reporter:  strk      |      Owner:  strk
      Type:  defect    |     Status:  assigned
  Priority:  blocker   |  Milestone:  PostGIS 3.5.0
 Component:  topology  |    Version:  master
Resolution:            |   Keywords:  regression
-----------------------+---------------------------
Comment (by strk):

 From #postgresql IRC channel on libera.chat:
 {{{
 11:59:43 RhodiumToad | so the basic logic is this
 12:00:09 RhodiumToad | given a <> b, we first find all visible '<>'
 operators
 12:00:36 RhodiumToad | then we see whether we can implicitly cast a and b
 to the argument types of those operators
 12:00:54 RhodiumToad | if the resulting list contains exactly one
 operator, then we use that one, otherwise it's an error
 12:01:14 RhodiumToad | (this is given that a and b have known types
 already, there's more to it if either is unknown)
 12:02:34 RhodiumToad | (if there's an exact match, that'll be taken over
 any operator that requires a cast)
 12:03:07 RhodiumToad | in this case, there are two equally good matches:
 record <> record and geometry <> geometry
 12:03:30 RhodiumToad | since all composite types can be implicitly cast to
 record, and there's also an implicit cast to geometry
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5546#comment:7>
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.


More information about the postgis-tickets mailing list