[postgis-users] point in polygon

[Paul Hastings]

i'm trying to get up to speed w/postgis & seem to have an issue with
point in polygon searches:

select prov_eng
from provinces
where GeometryFromText('POINT(100.65 23.85)', 4240) && the_geom;

the data is same SRID (4240) & i'm darned sure that point falls
someplace in that data. polygon on polygon, etc. searchs seem to work
fine (though these use existing geometry not built on the fly
geometry).

any ideas?

thanks.