[postgis-users] MapServer subquery problem

[René F. Viancos S.]

Try with 
 DATA "the_geom from(SELECT oid, gid, table1.the_geom AS the_geom FROM
table1, table2 WHERE distance(table1.the_geom, table2.the_geom) < 1000)
as foo using unique gid using srid=-1"
 include "oid" and/or "gid" in the select statement
 Regards
-- 
René F. Viáncos S.
Ingeniero Consultor en Geomática y TIC
Vicerrectoría de Investigación y Desarrollo
Universidad de Chile
Tel (56-2) 632 51 15
Cel (56 9) 933 72 66
rviancos at uchile.cl
rviancos at gmail.com
www.investigacion.uchile.cl <http://www.investigacion.uchile.cl>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050831/cb25900a/attachment.html>