[PostGIS] #5718: `st_isvalid(point(NaN, NaN))` is true
    PostGIS 
    trac at osgeo.org
       
    Wed Apr 24 20:41:01 PDT 2024
    
    
  
#5718: `st_isvalid(point(NaN, NaN))` is true
----------------------+---------------------
  Reporter:  n0099    |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:
 Component:  postgis  |    Version:  3.4.x
Resolution:           |   Keywords:
----------------------+---------------------
Comment (by robe):
 As @mdavis pointed out to me in IRC, there is no representation for
 POINT(NaN NaN) in WKB so it gets read as POINT EMPTY which is valid.
 However I can create a real NaN as follows and PostGIS does return false:
 ```
 SELECT *, st_isvalid(a), st_x(a), st_y(a)
 FROM (SELECT ST_GeomFromText('POINT(NaN NaN)') a) t;
 ```
 Yields as you'd expect
 {{{
  Invalid Coordinate at or near point nan nan
                      a                      | st_isvalid | st_x | st_y
 --------------------------------------------+------------+------+------
  0101000000000000000000F87F000000000000F87F | f          |  NaN |  NaN
 (1 row)
 }}}
 So only question is if it's worthwhile throwing an error or keeping the
 wkb casting as POINT EMPTY
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5718#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.
    
    
More information about the postgis-tickets
mailing list