[postgis-users] query question

[G. van Es]

Hi All,

Maybe a newbie question, sorry for that.

We want to know wich objects of a certain type touches objects (multipolygon) of another type. Let me explain my silly statement.

The table T looks simplified like:

type | the_geom (multipolygon)
==============================
13   | ....
13   | ....
11   | ....
14   | ....
11   | ....
15   | ....
15   | ....

I want to have a list of wich geometry of a certain type is touching or crossing another type.

Can someone point me in the right direction?

Thanks a lot,

Ge