[postgis-users] subquery on a postgis layer

[Markus Schaber]

Hi, Toni,

toni hernnadez wrote:

> Is it possible to use the intersection function (or any other spacial
> postgis function) on two postgis tables with  a  postgis layer on
> mapserver?

Yes, it should be, but it's possible that you need to create a view and
appropriate geometry_columns entry.

For proper help, we need more details (do you UNION, JOIN or sub-SELECT
the two tables together, what should intersect etc.).

HTH,
Markus
-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org