[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] MapServer subquery problem
From:       René_F._Viancos_S. <rviancos () gmail ! com>
Date:       2005-08-31 18:20:07
Message-ID: 842c1e6605083111207ce2e8eb () mail ! gmail ! com
[Download RAW message or body]

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@uchile.cl
rviancos@gmail.com
www.investigacion.uchile.cl <http://www.investigacion.uchile.cl>

[Attachment #3 (text/html)]

<div>Try with </div>
<div>&nbsp;</div>
<div>DATA &nbsp; &nbsp; &nbsp; &nbsp;&quot;the_geom from(SELECT oid, gid, \
table1.the_geom AS the_geom FROM<br>table1, table2 WHERE distance(table1.the_geom, \
table2.the_geom) &lt; 1000)<br>as foo using unique gid using srid=-1&quot;</div> \
<div>&nbsp;</div> <div>include &quot;oid&quot; and/or &quot;gid&quot; in the select \
statement</div> <div>&nbsp;</div>
<div>Regards<br>-- <br>René F. Viáncos S.<br>Ingeniero Consultor en Geomática y \
TIC<br>Vicerrectoría de Investigación y Desarrollo<br>Universidad de Chile<br>Tel \
(56-2) 632 51 15<br>Cel (56 9) 933 72 66<br><a href="mailto:rviancos@uchile.cl"> \
rviancos@uchile.cl</a><br><a \
href="mailto:rviancos@gmail.com">rviancos@gmail.com</a><br><a \
href="http://www.investigacion.uchile.cl">www.investigacion.uchile.cl</a><br>&nbsp;</div>




[prev in list] [next in list] [prev in thread] [next in thread]