[mapserver-users] Problem with postgis layer

[Tyler Mitchell]

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 at refractions.net>           To:       Twan Kogels <twan at twansoft.com>,                         
                      Sent by:                             mapserver-users at lists.gis.umn.edu                                 
                      owner-mapserver-users at 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 at refractions.net
     | Phone: (250) 885-0632
     \_