[postgis-users] subquery on a postgis layer

Markus Schaber schabi at logix-tt.com
Mon Mar 13 01:43:14 PST 2006

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.).

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

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

More information about the postgis-users mailing list