postgis (INTERSECTION)

[Thip]

Dear all, 

I need to create one layer on fly using intersection. (Layer name are twy_sec and twy_su, new layer name is twy_intersection) SO I write down in the map file which is not working. Does anyone have suggestion?

LAYER
CONNECTIONTYPE postgis

CONNECTION "user=postgres password=pt dbname=apms host=localhost"

DATA "intersection(twy_sec.the_geom, twy_su.the_geom) from twy_sec, twy_su as foo using gid using SRID=-1"

NAME twy_intersection

TYPE POLYGON

STATUS ON

# CLASSITEM "layer"

#LABELITEM "no_id"

#LABELMINSCALE 3000

LABELMAXSCALE 10000

TEMPLATE twy_su.html



Do I have to put classitem? 



Thanks in advance. 

Thip
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20050831/fe71df08/attachment.htm>