[postgis-tickets] [PostGIS] #3484: IS DISTINCT FROM not seeing additional points

[PostGIS]

#3484: IS DISTINCT FROM not seeing additional points
-----------------------+---------------------------
  Reporter:  pvalsecc  |      Owner:  pramsey
      Type:  defect    |     Status:  new
  Priority:  medium    |  Milestone:  PostGIS 2.2.2
 Component:  postgis   |    Version:  2.2.x
Resolution:            |   Keywords:
-----------------------+---------------------------

Comment (by pvalsecc):

 Replying to [comment:1 strk]:
 > I guess "IS DISTINCT FROM" uses the btree index, which is based on
 bounding box (2d, float) comparison. Do you confirm it makes sense when
 casting those geometries to BOX2D ?

 I don't understand. My example is not using an index. And that would be
 wrong to only compare bounding boxes! Postgres documentation for "IS
 DISTINCT FROM" says:

 {{{
 For non-null inputs, IS DISTINCT FROM is the same as the <> operator.
 }}}

 For the context, I was using that in a "on update" trigger to check if a
 row is really modified before updating the {{{modified}}} column. My
 trigger was missing modifications.

 [1] http://www.postgresql.org/docs/9.1/static/functions-comparison.html

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3484#comment:3>
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.