I'm working in a project and I need to use postgis to get all the States contains in a City, now, I tried the following query:
SELECT * FROM Table1, Table2 WHERE ST_Contains(Table1.the_geom, Table2.the_geom) and Table1.id = 4
The query returns some of the locations but not all (exactly 6 of 13).
Maybe another better method for this? or I'm dealing with a bad DB ?