Opened 3 years ago
Last modified 17 months ago
#5175 closed defect
<> and != on geometry yield operator is not unique — at Initial Version
Reported by: | robe | Owned by: | pramsey |
---|---|---|---|
Priority: | medium | Milestone: | PostGIS 3.5.0 |
Component: | postgis | Version: | 3.0.x |
Keywords: | Cc: |
Description
Reported on IRC someone trying to create a trigger with construct:
(NEW.geom != OLD.geom)
yielded != is not unique for geometry. had to resort to
(NEW.geom::text != OLD.geom::text)
I verified it is an issue with
SELECT ST_Point(1,2) != ST_Point(3,4); SELECT ST_Point(1,2) <> ST_Point(3,4);
However this works fine:
SELECT ST_Point(1,2)::geography != ST_Point(3,4)::geography; SELECT ST_Point(1,2)::geography <> ST_Point(3,4)::geography;
I haven't verified where the extra operator indirection is coming from that is not effecting geography as well.
Note:
See TracTickets
for help on using tickets.