[postgis-tickets] [PostGIS] #2700: pgsql2shp output 2D when null geom in 3D table

[PostGIS]

#2700: pgsql2shp output 2D when null geom in 3D table
---------------------------------------+------------------------------------
 Reporter:  RemiC                      |       Owner:  mcayland     
     Type:  defect                     |      Status:  new          
 Priority:  medium                     |   Milestone:  PostGIS 2.1.3
Component:  loader/dumper              |     Version:  trunk        
 Keywords:  pgsql2shp null geom 3D 2D  |  
---------------------------------------+------------------------------------

Comment(by strk):

 I think the problem is with max(ST_ZMFlag(geom)) returning null on null
 geometries and thus being interpreted as 0 as the max. A COALESCE should
 help.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2700#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.