[mapserver-users] simplify problem

[ahlah]

Hi,

I'm trying to use ST_Simplify function of Postgis in Mapserver

This data source works fine in my mapfile of Mapserver:
DATA 'geom_3067 from lines using srid=3067 using unique id'

ST_Simplify query works fine inside Postgis:
select ST_Simplify(geom_3067,100) from lines; 

But when I'm trying to use simplify function like this in mapfile, mapserver
throws error:
DATA 'ST_Simplify(geom_3067,100) from lines using srid=3067 using unique id'

msDrawMap(): Image handling error. Failed to draw layer named 'grid'.
msPostGISLayerWhichShapes(): Query error. Error (ERROR:  column
"ST_Simplify(geom_3067,100)" does not exist
LINE 1: ...status",encode(AsBinary(force_collection(force_2d("ST_Simpli...
                                                             ^
This is the query sent by mapserver:
select
"status",encode(AsBinary(force_collection(force_2d("ST_Simplify(geom_3067,100)")),'NDR'),'hex')
as geom,"id" from lines where ST_Simplify(geom_3067,100) &&
GeomFromText('POLYGON((365203 7272028.2777498,365203 7661628.2777498,724803
7661628.2777498,724803 7272028.2777498,365203 7272028.2777498))',3067)

It seems that mapserver handles "ST_Simplify(geom_3067,100)" like a database
column. Is there something wrong in my syntax?

Thanks in advance

AL

--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/simplify-problem-tp7135648p7135648.html
Sent from the Mapserver - User mailing list archive at Nabble.com.