PostGIS Question

[Paul Spencer]

Steve,

I can't answer the question with a high level of certainty, but if you 
run postmaster with a certain level of debugging and monitor your logs, 
you will see the full SQL statement that gets built for a layer draw and 
I believe that it contains this kind of constraint.

If you don't get a better answer here, I'd suggest posting to the 
postgis list, I'm not sure how closely Paul R. monitors this list ;)

Paul

Stephen Woodbridge wrote:
> I'm newbie to PostGIS, I am wondering if the mapserver integration uses 
> the PostGIS spatial indexes when rendering a map or if it needs to be 
> made explicitly in the layer definition?
> 
> Does the final SQL do something like:
> 
> select whatever, the_geom
>   from table
> where the_geom && bbox2d(image_extents) and ...
> 
> I am guessing/hoping it probably does. Is there an easy way to get 
> mapserver to  dump the SQL to a log file for inspection?
> 
> Thanks,
>   -Steve W.
> 

-- 
+-----------------------------------------------------------------+
|Paul Spencer                           pspencer at dmsolutions.ca   |
+-----------------------------------------------------------------+
|Applications & Software Development                              |
|DM Solutions Group Inc                 http://www.dmsolutions.ca/|
+-----------------------------------------------------------------+