[postgis-users] point in polygon

[TECHER Jean David]

try

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

----------------------------------------------------------------
TECHER Jean David
Responsable Informatique 01MAP
e-mail: davidtecher at yahoo.fr
------------------------------------------------------------
----- Original Message ----- 
From: "Paul Hastings" <paul.hastings at gmail.com>
To: <postgis-users at postgis.refractions.net>
Sent: Thursday, September 30, 2004 11:21 AM
Subject: [postgis-users] point in polygon


> 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.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users