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
postgresql
|postgis
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