Would it be more appropriate then to create a view that represents the data
in a simpler format in postgis and reference it directly instead?
Paul Ramsey
<pramsey@refractions.net> To: Twan Kogels <twan@twansoft.com>,
Sent by: mapserver-users@lists.gis.umn.edu
owner-mapserver-users@lists. cc:
gis.umn.edu Fax to:
Subject: Re: [mapserver-users] Problem with postgis layer
06/04/2002 07:59 AM
What you are doing wrong is inferring from the SQL-like syntax of the
DATA parameter that the values are actually being passed verbatim to the
SQL parser. They are not. They are being parsed by the postgis map
layer, and then used in SQL appropriately. So, your SQL riff on the
standard layout actually breaks the system.
Twan Kogels wrote:
> DATA "p.the_geom from pc6punten p"
> The layer doesn't return any results. Does anyone know what i'm doing
wrong?
--
__
/
| Paul Ramsey
| Refractions Research
| Email: pramsey@refractions.net
| Phone: (250) 885-0632
\_