AW: [mapserver-users] query in postgis works but in mapfile failed, why??

Eichner, Andreas - SID-NLKM Andreas.Eichner at sid.sachsen.de
Thu Oct 20 03:28:23 PDT 2011


> and the same in my mapfile gives nothing:
> 
> DATA                    'geom FROM (SELECT
> seismic_line.fid,seismic_line.profile,seismic_line.geom FROM 
> seismic_line,
> sar_contour_line WHERE seismic_line.geom && sar_contour_line.geom AND
> INTERSECTS(seismic_line.geom, sar_contour_line.geom) AND
> sar_contour_line.contour = -600) AS FOO USING UNIQUE fid USING UNIQUE
> SRID=4326'
> 
> why??

Should probably be "...) AS FOO USING UNIQUE fid USING SRID=4326'" -
without the "UNIQUE" in front of "SRID".



More information about the MapServer-users mailing list