How do I use ST_Contains in following case?

Posted by Z77 on Stack Overflow See other posts from Stack Overflow or by Z77
Published on 2010-06-02T08:29:00Z Indexed on 2010/06/02 8:33 UTC
Read the original article Hit count: 154

Filed under:
|

I have two tables. First with points, and second with polygons. I need to find out which points are in required polygon according to the attribute gid.

Using query: SELECT table1.* FROM table1, table2 WHERE table2.gid=1 AND ST_Contains(table2.geom2, table1.geom1);

What I get is empty table (only columns without data)...

Tnx

© Stack Overflow or respective owner

Related posts about postgresql

Related posts about postgis